Begin transaction
use Test
insert into Student values('004','name1',30)
save tran my_sa
delete from Student where [Name] = 'name1'
rollback tran my_sa
commit tran
go
|
Begin transaction use Test insert into Student values('004','name1',30) save tran my_sa delete from Student where [Name] = 'name1' rollback tran my_sa commit tran go 
|