begin transaction
declare @errSUM int
set @errSUM=0
update spml2 set cksj=cksj-20 where spbh='1002'
set @errSUM=@errSUM+@@ERROR
update spml2 set cksj=cksj+20 where spbh='1001'
set @errSUM=@errSUM+@@ERROR
if @errSUM<>0
begin
rollback transaction
end
else
begin
commit transaction
end
大家看下我这个事务
其中spbh='1001'是不存在的
但是怎么update spml2 set cksj=cksj-20 where spbh='1002'就执行了