![A Primer on Stored Procs, Locks, Transaction Commits & Query Plans in Microsoft SQL Server | by Subha Ganapathi | Geek Culture | Medium A Primer on Stored Procs, Locks, Transaction Commits & Query Plans in Microsoft SQL Server | by Subha Ganapathi | Geek Culture | Medium](https://miro.medium.com/v2/resize:fit:1400/1*fIxxcum8u3DyADh5Xw-4ag.png)
A Primer on Stored Procs, Locks, Transaction Commits & Query Plans in Microsoft SQL Server | by Subha Ganapathi | Geek Culture | Medium
![SQL SERVER - Transaction and Local Variables - Swap Variables - Update All At Once Concept - SQL Authority with Pinal Dave SQL SERVER - Transaction and Local Variables - Swap Variables - Update All At Once Concept - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/localvars.gif)
SQL SERVER - Transaction and Local Variables - Swap Variables - Update All At Once Concept - SQL Authority with Pinal Dave
![Get the current transaction state of user request using XACT_STATE() – SQL Server – SQL Server Rider Get the current transaction state of user request using XACT_STATE() – SQL Server – SQL Server Rider](https://sqlserverrider.files.wordpress.com/2013/02/pic130.png?w=640)