T-SQL Tutorial

T-SQL Rollback Work


The ROLLBACK WORK is an transaction operation that rolls back a user specified transaction.

Rollback work syntax:

ROLLBACK [ WORK ] ;

Rollback work example:

USE model;
GO
BEGIN TRANSACTION;
GO
insert into students(id,first_name, last_name, gender,city, country, section)
values(8,'Alysia','MARTIN','F','Toronto','Canada', 'Biology');
GO
ROLLBACK WORK;
GO