Create Table Demo
(
DemoID Int,
DemoData varchar(100)
)
DECLARE @T1 varchar(20) = 'T1';
DECLARE @T2 varchar(20) = 'T2';
DECLARE @T3 varchar(20) = 'T3';
Begin Tran
Insert into Demo Values (1, 'Kamlesh')
SAVE TRANSACTION p1;
Insert into Demo Values (2, 'Singh')
SAVE TRANSACTION p2;
Insert into Demo Values (3, 'Akshat')
SAVE TRANSACTION p3;
ROLLBACK TRAN p2;
select * from Demo
COMMIT TRAN
Delete from Demo
No comments:
Post a Comment