Discussion Board

@@TRANCOUNT The @@TRANCOUNT is used to determine whenever a transaction is still open. It returns the number of active transactions for the current connection. It increments the count value whenever we open a transaction and decrements the count whenever we commit the transaction. Rollback sets the trancount to zero and transaction with save point does to affect the trancount value. It helps application to keep track of the open transactions. Prajakta Pandit 03-6-2017 06:19 AM

transaction open state @@TRANCOUNT The nesting level of transactions. Each begin transaction in a batch increments the transaction count. When you query @@trancount in chained transaction mode, its value is never zero since the query automatically initiates a transaction. Return type: int transaction open 05-3-2016 02:24 AM

SQL ????? Suman rawat 03-23-2015 12:45 AM

gg Ggggg abhishek 12-17-2014 11:10 PM

Write your comments

*

* Email must be in the form someone@domain.com

*

*