Transactions in Stored Procedures

Erik Darling continues a series on stored procedures:

Transactions and error handling often go hand-in-glove, to make better use of XACT_ABORT, manually manage rollbacks, and try to make the best use of all those ACID properties that database people seem to care deeply about.

Click through for Erik’s advice around transaction handling.