declare @t table(id int,name varchar(50))
begin tran
insert into @t values(1,'aaa')
BEGIN TRAN
insert into @t values(1,'bbb')
SAVE TRAN A
insert into @t values(1,'ccc')
COMMIT TRAN
commit tran
select * from @t
/*
id name
1 aaa
1 bbb
1 ccc
*/
declare @t table(id int,name varchar(50))
begin tran
insert into @t values(1,'aaa')
BEGIN TRAN
insert into @t values(1,'bbb')
SAVE TRAN A
insert into @t values(1,'ccc')
COMMIT TRAN
rollback TRAN A