Answer: Returns the number of active transactions for the current connection.
PRINT @@TRANCOUNT
-- The BEGIN TRAN statement will increment the transaction count by 1.
BEGIN TRAN
PRINT @@TRANCOUNT
-- The COMMIT statement will decrement the transaction count by 1.
COMMIT
PRINT @@TRANCOUNT
--Results
--0
--1
--0
Asked In: Many Interviews |
Alert Moderator