begin tran
insert ...
if @@error <> 0
begin
rollabck transaction
return
end
insert ...
if @@error <> 0
begin
rollabck transaction
return
end
commit
insert ...
if @@error <> 0
begin
rollabck transaction
return
end
insert ...
if @@error <> 0
begin
rollabck transaction
return
end
commit
IF @@ERROR <>0 --错误就回滚
BEGIN
ROLLBACK TRAN
RETURN
ENDCOMMIT TRAN --正确就释放