General information
Title:
Wrapping all SQL updates into one transaction
I have a rather complicated module which performs multiple updates and inserts to multiple back-end tables (on SQL Server), and it's an "all or nothing" kind of process. Can someone please show me a way to wrap all of my SQL update statements so that if something would of failed, it will rollback all of my changes to all of the tables?
Thanks in advance for your input.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only