"An SQL-transaction (transaction) is a sequence of executions of SQL-statements that is atomic with respect to recovery. That is to say: either the execution result is completely successful, or it has no effect on any SQL-schemas or SQL-data."
— The SQL Standard
-
About SQL Transactions
A transaction is an ordered set of operations (of SQL statements). The effe... -
Initiating Transactions
A transaction begins, if it hasn't already begun, when one of these SQL sta... -
Terminating Transactions
There are two transaction-terminating statements: COMMIT and ROLLBACK. The ... -
COMMIT statement
The COMMIT statement ends a transaction, saving any changes to SQL-data so ... -
The Two-Phase COMMIT
In an ordinary situation, COMMIT is an instruction to the DBMS, and it's be... -
SAVEPOINT statement
The SAVEPOINT statement establishes a savepoint at the current point in the... -
ROLLBACK statement
The ROLLBACK statement rolls back (ends) a transaction, destroying any chan... -
ROLLBACK ... TO SAVEPOINT
The most beneficial new SQL3 feature, in transaction contexts, is the abili... -
RELEASE SAVEPOINT statement
The RELEASE SAVEPOINT statement destroys one or more savepoints in the curr... -
Transaction Tips
The following tips are viable only if the DBMS is alone, is following the S... -
Using Savepoints
A savepoint may be thought of as a label of a moment between operations. Fo... -
See Also
All SQL operations have something to do with transactions. This chapter has... -
Dialects
SQL has supported transaction work since the early days (SQL-86). There are...
