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
转载于:https://www.cnblogs.com/MichaelShang/archive/2012/12/15/2819213.html