transaction sql

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