T-SQL Commit work transaction
The COMMIT WORK transaction is the end point of a successful transaction.
Commit work syntax:
COMMIT [ WORK ] ;
Commit work example:
DELETE FROM students WHERE id = 7 ;
insert into students(id,first_name, last_name, gender,city, country, section)