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

Posted by Raja on 3/15/2009 | Category: Sql Server Interview questions | Views: 44296

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

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