这样写 主要结构 begin tran delete tblPhoneOperation_DoFeedBk where fid = @ID if @@error <>0 begin RollBack Tran return (-1) end delete tblPhoneOperation_Do where fid = @ID if @@error <>0 begin RollBack Tran return (-2) end delete tblPhoneOperation where id = @ID if @@error <>0 begin RollBack Tran return (-3) endcommit tran return(1) GO
事务 begin tran insert A select 1 insert B select 2 if @@error<>0 begin rollback tran return end commit tran
rollback
else
commit
主要结构
begin tran
delete tblPhoneOperation_DoFeedBk where fid = @ID
if @@error <>0
begin
RollBack Tran
return (-1)
end
delete tblPhoneOperation_Do where fid = @ID
if @@error <>0
begin
RollBack Tran
return (-2)
end
delete tblPhoneOperation where id = @ID
if @@error <>0
begin
RollBack Tran
return (-3)
endcommit tran
return(1)
GO
begin tran
insert A select 1
insert B select 2
if @@error<>0
begin
rollback tran
return
end
commit tran