Commits the current transaction to the database. This command makes the database updates from the transaction permanent.
Syntax
COMMIT [ WORK | TRANSACTION ]Parameters
- WORK
-
Optional keyword. This keyword isn't supported within a stored procedure.
- TRANSACTION
-
Optional keyword. WORK and TRANSACTION are synonyms. Neither is supported within a stored procedure.
For information about using COMMIT within a stored procedure, see Managing transactions.
Examples
Each of the following examples commits the current transaction to the database:
commit;commit work;commit transaction;