sql删除主附表事务回滚处理

declare@err int;

begin tran

删除副表语句;

set @err = @@error;

删除主表语句;

set @err = @err + @@error;

if @err = 0

begin

commit   //成功

select 1

end

else

begin

rollback  //失败

select 0

end