事务回滚的问题？急！！

Question

alter proc sp_Insert
(
@cardid nvarchar(50),
@klx int,
@khbh nvarchar(50),
@czy_bh nvarchar(50),
@bmbh nvarchar(50)
)
as
begin
begin tran TranProcInsert insert into cardinfo (cardid,klx,kmm,khbh,czy_bh,bmbh)
values(@cardid,@klx,'888',@khbh,@czy_bh,@bmbh)if  @@ERROR <> 0
rollback; insert into CardLog(czy_bh,purviewid,result,description) 
values(@czy_bh,'发卡模块','发卡成功',@cardid+'卡发放成功') 

insert into cardbill (cardid,OpType,OpCZY_BH,bmbh,description,klx)
values(@cardid,'发卡管理',@czy_bh,@bmbh,@cardid+'卡发放成功',@klx)commit tran
end

Answer 1

无语,自己看一下SQLServer帮助就行了

Answer 2

alter proc sp_Insert
(
@cardid nvarchar(50),
@klx int,
@khbh nvarchar(50),
@czy_bh nvarchar(50),
@bmbh nvarchar(50)
)
as
begin
begin tran TranProcInsert insert into cardinfo (cardid,klx,kmm,khbh,czy_bh,bmbh)
values(@cardid,@klx,'888',@khbh,@czy_bh,@bmbh)
if @@ERROR <>0 
         begin
             roolback;
             return;
         end
insert into CardLog(czy_bh,purviewid,result,description) 
values(@czy_bh,'发卡模块','发卡成功',@cardid+'卡发放成功') 
if @@ERROR <>0 
         begin
             roolback;
             return;
         end
insert into cardbill (cardid,OpType,OpCZY_BH,bmbh,description,klx)
values(@cardid,'发卡管理',@czy_bh,@bmbh,@cardid+'卡发放成功',@klx)
if @@ERROR <>0 
         begin
             roolback;
             return;
         end
commit tran
end