Geeks With Blogs
Brian Biales because blogging is just the easiest way to remember things March 2012 Entries
How to nest transactions nicely - "begin transaction" vs "save transaction" and SQL Server
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 figured out how to handle the case when we are already in a transaction, as well as the case where the caller did not start a transaction. When a problem occurred, my ......

Posted On Thursday, March 15, 2012 4:27 PM

Copyright © Brian Biales | Powered by: