Articles → SQL SERVER → @@Transactioncount In SQL Server

@@Transactioncount In SQL Server

In this article, we will discuss "@@TransactionCount" in the SQL server.

Purpose

"@@TransactionCount" returns the number of "Begin Transaction" statements in the current connection.

Impact Of Commit And Rollback On "@@Transactioncount"

The "Commit" statement reduces the "@@TransactionCount" to 1 and the rollback statement resets the "@@TransactionCount" to zero.

Example

PRINT @@TRANCOUNT -- Count  = 1
BEGIN TRAN -- Set @@TransactionCount = 2
PRINT @@TRANCOUNT BEGIN TRAN -- Set @@TransactionCount = 3 
Rollback -- Resets @@TransactionCount to zero
PRINT @@TRANCOUNT BEGIN TRAN -- Set @@TransactionCount = 1 
BEGIN TRAN -- Set @@TransactionCount = 2
COMMIT -- Reduces @@TransactionCount  to 1
PRINT @@TRANCOUNT BEGIN TRAN -- Set @@TransactionCount = 2
COMMIT -- Reduces @@TransactionCount  to 1
PRINT @@TRANCOUNT

Output

Posted By -	Karan Gupta

Posted On -	Thursday, October 5, 2017

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**