COMMIT WORK - TSQL Tutorial

The COMMIT WORK transaction is the end point of a successful transaction.

Commit work syntax:

COMMIT [ WORK ] ;

Commit work example:

USE model;
GO
BEGIN TRANSACTION;
GO
DELETE FROM students WHERE id = 7 ;
GO
insert into students(id,first_name, last_name, gender,city, country, section)
values(7,'Ashley','THOMPSON','F','Liverpool','England', 'History');
GO
COMMIT WORK;
GO