SQL - Structured Query Language

@@TRANCOUNT


@@TRANCOUNT is used to returns the number of BEGIN Transaction statements that have occurred on the current database connection.
BEGIN and COMMIT Example
The following example displays the effect that nested BEGIN and COMMIT statements have on the @@TRANCOUNT variable.

-- Example 70 --

 

USE EBusiness

GO

 

PRINT @@TRANCOUNT -- The result is 0

BEGIN TRAN --Increment variable value 1 from existing value 0

     PRINT @@TRANCOUNT -- The result is 1

     BEGIN TRAN -- Increment variable value 1 from existing value 1

          PRINT @@TRANCOUNT -- The result is 2

     COMMIT -- Decrement variable value 1 from existing value 2

      PRINT @@TRANCOUNT -- The result is 1

COMMIT -- Decrement variable value 1 from existing value 1

PRINT @@TRANCOUNT -- The result is 0


Query Output Screen

BEGIN and ROLLBACK Example
The following example displays the effect that nested BEGIN TRAN and ROLLBACK statements have on the @@TRANCOUNT variable.

-- Example 71 --

 

USE EBusiness

GO

 

PRINT @@TRANCOUNT -- The result is 0

BEGIN TRAN -- Increment variable value 1 from existing value 0

     PRINT @@TRANCOUNT -- The result is 1

     BEGIN TRAN -- Increment variable value 1 from existing value 1

          PRINT @@TRANCOUNT -- The result is 2

ROLLBACK -- Clear variable value and stores 0

PRINT @@TRANCOUNT -- The result is 0


Query Output Screen

* * * * *

Email Your Comment To AUTHOR

Quick Links
Home
About Me
System Analyze Method
Dimensional Data Model
Entity Relationship Model
Relational Database Model
Tutorials
MS SQL Server - DBA
SSIS - Video Tutorials
SSAS - Video Tutorials
SSRS - Video Tutorials
SQL Server White Papers
Programming in SQL Server
Help Us
Contact Me
R.K.Prem Nath
Madurai District
Tamil Nadu, India

[email protected]
[email protected]
Terms Of Use                                                  Protected by Copyscape Online Plagiarism Tool             Copyrights © 2022. Data-e-Education. All Rights Reserved.