CREATE PROCEDURE mysp
as
begin
begin tran
...
delete T1
if @@error <> 0
goto error_handler
delete T2
if @@error <> 0
goto error_handler commit tran
return 1
error_handler:
rollback
return -1
end
as
begin
begin tran
...
delete T1
if @@error <> 0
goto error_handler
delete T2
if @@error <> 0
goto error_handler commit tran
return 1
error_handler:
rollback
return -1
end
if @@error <> 0
goto error_handler 可以吗,表不存在,这句话不会产生错误的
如果捕获的话,应该就不用做滚回了,因为你还有error_handler呢