The document is archived and information here might be outdated
Returns the number of active transactions for the current connection.
This example uses @@TRANCOUNT to test for open transactions that should be committed.
USE AdventureWorks; GO BEGIN TRANSACTION; GO UPDATE Person.Contact SET LastName = UPPER(LastName) WHERE LastName = 'Wood'; GO IF @@TRANCOUNT > 0 BEGIN PRINT N'A transaction needs to be rolled back.'; ROLLBACK TRANSACTION; END