What is @@trancount in sql server?

Amit Aggarwal

10y7.9k

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Kumar10y ago
Hi Dear,

The BEGIN TRANSACTION statement increments @@TRANCOUNT by 1.
ROLLBACK TRANSACTION decrements @@TRANCOUNT to 0,
except for ROLLBACK TRANSACTION savepoint_name,
which does not affect @@TRANCOUNT.
COMMIT TRANSACTION or COMMIT WORK decrement @@TRANCOUNT by 1.

For more Information see below link.

http://www.dotnetfunda.com/interviews/show/413/what-is-the-use-of-trancount-in-sql-server

https://msdn.microsoft.com/en-IN/library/ms187967.aspx

http://www.dailyfreecode.com/code/trancount-trancount-function-437.aspx
Amit Kumar Singh10y ago
1.https://msdn.microsoft.com/en-IN/library/ms187967.aspx

2.http://www.dotnetfunda.com/interviews/show/413/what-is-the-use-of-trancount-in-sql-server
Abdu Rafeeq10y ago
Returns the number of BEGIN TRANSACTION statements that have occurred on the current connection.

pls refer the link

https://msdn.microsoft.com/en-us/library/ms187967.aspx
ali tuncer10y ago
Returns the number of BEGIN TRANSACTION statements that have occurred on the current connection.
https://sqlserverrider.wordpress.com/2013/02/04/trancount-sql-server/