TRANSACTION
Menu
The following is very useful when testing insert and update queries. This allows you to insert a record then view it. If there is a problem it can then be easily rolled back. Little but like setting an ’undo’ button in SQL.
BEGIN TRANSACTION T1
- SQL statements...
ROLLBACK TRANSACTION T1
To commit:
BEGIN TRANSACTION T1
- SQL statements...
COMMIT TRANSACTION T1
Copyright 2012. All rights reserved.
