事务回滚的问题？急！！

[setcs_lina]

--sp_Insert 向三个表中插入数据（CardInfo,OpLog,CardBill）
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)

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

以上有一个语句插入不成功，如果让它回滚？

[NekChan]

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

[zincy]

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

[yyq136]

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

[setcs_lina]

搞定了。谢谢大家了啊！