begin tran
update t1 ...
if @@error <> 0 begin
rollback tran
--goto labend
-- return
end
delete t2 ...
if @@error <> 0 begin
rollback tran
--goto labend
end
commit tran
labend:
go