....
begin
begin TRANSACTION
insert into yezhu values (@cardid,@cardname,@fahaotime,@yj,@zhujie)
IF @@ERROR<>0 GOTO Errhandler
insert into jiaofei values (@cardid,@time1,@time2)
IF @@ERROR<>0 GOTO Errhandler
insert into tempdaka1 (Card_id,yj_user) values (@cardid,@yj)
IF @@ERROR<>0 GOTO Errhandler
commit TRANSACTION
return 2
Errhandler:
Rollback Tran
end
....
begin
begin TRANSACTION
insert into yezhu values (@cardid,@cardname,@fahaotime,@yj,@zhujie)
IF @@ERROR<>0 GOTO Errhandler
insert into jiaofei values (@cardid,@time1,@time2)
IF @@ERROR<>0 GOTO Errhandler
insert into tempdaka1 (Card_id,yj_user) values (@cardid,@yj)
IF @@ERROR<>0 GOTO Errhandler
commit TRANSACTION
return 2
Errhandler:
Rollback Tran
end
....
begin
declare @error int
set @error = 0
begin TRANSACTION
insert into yezhu values (@cardid,@cardname,@fahaotime,@yj,@zhujie)
@error = @error + @@error
insert into jiaofei values (@cardid,@time1,@time2)
@error = @error + @@error
insert into tempdaka1 (Card_id,yj_user) values (@cardid,@yj)
@error = @error + @@error
if @error = 0
begin
commit TRANSACTION
return 2
end
else
Rollback Tran
end
....
begin
SET XACT_ABORT
begin TRANSACTION
insert into yezhu values (@cardid,@cardname,@fahaotime,@yj,@zhujie)
insert into jiaofei values (@cardid,@time1,@time2)
insert into tempdaka1 (Card_id,yj_user) values (@cardid,@yj)
commit TRANSACTION
return 2
end