COMMIT

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 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

Examples

COMMIT

"Once a journalist makes a commitment of confidentiality to a source, only the source can end that commitment” ~ Matt Cooper

Related commands

COMMIT TRANSACTION
CHECKPOINT

Equivalent Oracle command:

COMMIT