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