What is @@trancount in sql server?

Question

Amit Kumar · Answer

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 Singh · Answer

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 Rafeeq · Answer

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 tuncer · Answer

Returns the number of BEGIN TRANSACTION statements that have occurred on the current connection. https://sqlserverrider.wordpress.com/2013/02/04/trancount-sql-server/

What is @@trancount in sql server?

Answers (4)