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