How to nest transactions nicely - "begin transaction" vs "save transaction" and SQL Server
- by Brian Biales
Do you write stored procedures that might be used by others? And those others may or may not have already started a transaction? And your SP does several things, but if any of them fail, you have to undo them all and return with a code indicating it failed? Well, I have written such code, and it wasn’t working right until I finally…