Which global variables can be used to determine if a transaction is still open?
A. @@NESTLEVEL
B. @@FETCH_STATUS
C. @@TRANCOUNT
D. @@CONNECTIONS
Answer:A
Which global variables can be used to determine if a transaction is still open?
A. @@NESTLEVEL B. @@FETCH_STATUS C. @@TRANCOUNT D. @@CONNECTIONS
Explanation:PRINT @@TRANCOUNT — The BEGIN TRAN statement will increment the — transaction count by 1.