begin tran insert tb select * from tb1 update tb set ... delete tb where if @@error=0 commit else rollback
CREATE procedure sp_DeleteUser @uName varchar(20) as declare @TotalError int set @TotalError=0 begin tran delete from suser where susname=@uName set @TotalError=@TotalError+@@error delete from patrolmembers where pmnum=@uName set @TotalError=@TotalError+@@error delete from roleuser where userid=(select sUsNum from sUser where sUsName=@uName) set @TotalError=@TotalError+@@error if (@TotalError=0) begin commit tran end else begin rollback tran end GO
insert tb select * from tb1
update tb set ...
delete tb where
if @@error=0
commit
else
rollback
@uName varchar(20)
as
declare @TotalError int
set @TotalError=0 begin tran
delete from suser where susname=@uName
set @TotalError=@TotalError+@@error
delete from patrolmembers where pmnum=@uName
set @TotalError=@TotalError+@@error
delete from roleuser where userid=(select sUsNum from sUser where sUsName=@uName)
set @TotalError=@TotalError+@@error if (@TotalError=0)
begin
commit tran
end
else
begin
rollback tran
end
GO