What is the use of @@TRANCOUNT in SQL Server?

 Posted by Raja on 3/15/2009 | Category: Sql Server Interview questions | Views: 29565
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 

Comments or Responses

Login to post response