The usual
structure of the TRANSACTION is as follows:
BEGIN
TRANSACTION
Operations
COMMIT
TRANSACTION or ROLLBACK TRANSACTION
When Commit is
executed, every statement between BEGIN and COMMIT becomes persistent to
database. When Rollback is executed, every statement between BEGIN and ROLLBACK
are reverted to the state when BEGIN was executed.
No comments:
Post a Comment