34,838
社区成员




declare @result int=0;
begin tran
begin try
insert into table1 values('','');
if @@ROWCOUNT<>1
begin
set @result=-1;
goto rollback_label;
end
update table2 set filed1='' where id=@id;
if @@ROWCOUNT<>1
begin
set @result=-2;
goto rollback_label;
end
end try
begin catch
set @result=-255;
end catch
rollback_label:
if @result<>0
rollback tran;
else
commit tran;
return @result;