Mark the end of a transaction.
Syntax COMMIT COMMIT WORK COMMIT TRAN[SACTION] [transaction_name | @transaction_var]
A commit will make any data modifications performed since the start of the transaction a permanent part of the database.
transaction_name is simply used by programmers to associate a BEGIN TRANSACTION statement with a COMMIT TRANSACTION statement. It is ignored by the database engine.
The syntax COMMIT or COMMIT WORK is compatible with SQL-92
"Once a journalist makes a commitment of confidentiality to a source, only the source can end that commitment" - Matt Cooper
Equivalent Oracle command:
© Copyright SS64.com 1999-2013
Some rights reserved