SQL Server Transactions: Understanding COMMIT

What is COMMIT in SQL Server?

COMMIT is a SQL statement used to save all changes made during the current transaction permanently to the database.

Once a COMMIT is executed, the changes become visible to other users and cannot be undone by a ROLLBACK.

• Finalizes the transaction.
• Makes all changes permanent and durable.
• Releases any locks held during the transaction.

How to Use COMMIT

Typically, a transaction begins with BEGIN TRANSACTION, followed by one or more SQL statements.

After successful execution of these statements, COMMIT is issued to save the changes.

If an error occurs before COMMIT, ROLLBACK can be used to undo changes.

• Start with BEGIN TRANSACTION.
• Execute your SQL commands (INSERT, UPDATE, DELETE).
• Use COMMIT to save changes permanently.

COMMIT Example

The following SQL script shows a transaction that inserts a new record and commits the change.