需自己加eg:
create procedure test
As
begin tran
insert ...
if @@error<> 0 goto Err
delete...
if @@error<> 0 goto Err
update..
if @@error<> 0 goto Err
commit
return
Err:
rollback
create procedure test
As
begin tran
insert ...
if @@error<> 0 goto Err
delete...
if @@error<> 0 goto Err
update..
if @@error<> 0 goto Err
commit
return
Err:
rollback
As
begin transaction
insert ...
if @@error<> 0 or @@rowcount<=0 goto on_error
delete...
if @@error<> 0 goto on_error
update..
if @@error<> 0 goto on_error
commit
returnon_error:
rollback
return -1