transaction1.sql

来自「在学习SQL Server过程中整理的T-SQL语句」· SQL 代码 · 共 17 行

begin transaction
use test

insert into stucopy
   values('021','bb')
save tran my_sav

delete from stucopy
       where sno = '021'

begin
rollback
return
end

commit 
go