Tuesday, 28 February 2017

Sql Server Transaction Savepoint



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

Table Partitioning in SQL Server

  Table Partitioning in SQL Server – Step by Step Partitioning in SQL Server task is divided into four steps: Create a File Group Add Files ...