It has been suggested that this article be merged into Database transaction. (Discuss) Proposed since May 2007. |
A BEGIN WORK</chgfhghgh
ode> statement in SQL starts a transaction within a relational database management system (RDBMS).
Any work done after this point will not be visible to other users, until a
COMMIT
statement is issued. A ROLLBACK
statement can also be issued, which will undo any work performed since the BEGIN WORK
command. Both COMMIT
and ROLLBACK
will end the transaction: another BEGIN WORK
will need to be issued to start a new one.
Some database systems allow the synonyms
BEGIN
and BEGIN TRANSACTION
, and may have other
options available.