Sql server 事务

declare @Errorcount int =0
begin tran tran_20151106
insert into PatentFile values(1,1,1,1,1,1,11)
set @Errorcount=@Errorcount+@@error
insert into PatentFile values(1,1,1,1,1,1,11)
set @Errorcount=@Errorcount+@@error
if(@Errorcount<>0)
begin
rollback tran tran_20151106
end
else
begin
rollback tran tran_20151106
end

posted @ 2015-11-06 09:22  caichao  阅读(157)  评论(0编辑  收藏  举报