Difference between @@TranCount and Xact_State() :-
Both @@TranCount and Xact_State() are use to get the information about transaction in SQL Server.
The major difference between @@TranCount and Xact_State() is, @@TRANCOUNT does not report uncommittable transactions and XACT_STATE() does not report the transaction nesting level.
Both @@TranCount and Xact_State() are use to get the information about transaction in SQL Server.
The major difference between @@TranCount and Xact_State() is, @@TRANCOUNT does not report uncommittable transactions and XACT_STATE() does not report the transaction nesting level.
