Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using Transactions interactively as an undo
Message
 
 
To
19/04/2007 20:30:10
General information
Forum:
Microsoft SQL Server
Category:
Database management
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01218073
Message ID:
01218157
Views:
18
I want to do the changes interactively, not with code.

>
>BEGIN TRANSACTION T1
>
>   Update and Verify Data here
>
>if (Data Verified)
>   COMMIT TRANSACTION T1
>else
>   ROLLBACK TRANSACTION T1
>
>
>
>You may also Nested Transaction like this
>
>BEGIN TRANSACTION T1
>
>  BEGIN TRANSACTION T2
>
>   Update and Verify Data here
>  if (Data Verified)
>     COMMIT TRANSACTION T2
>  else
>     ROLLBACK TRANSACTION T2
>
>
>
>if (Data Verified)
>   COMMIT TRANSACTION T1
>else
>   ROLLBACK TRANSACTION T1
>
>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform