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

Example

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


© Copyright SS64.com 1999-2014
Some rights reserved