触发器是这样的update cwgl_tjbb_xj set cwgl_tjbb_xj.bqzj=cwgl_tjbb_xj.bqzj-deleted.je,lx='1' from deleted where deleted.je>=0 and cwgl_tjbb_xj.pzh=deleted.pzbh
update cwgl_tjbb_xj set cwgl_tjbb_xj.bqjs=cwgl_tjbb_xj.bqjs-deleted.je,lx='1' from deleted where deleted.je<0 and cwgl_tjbb_xj.pzh=deleted.pzbh表里面的数据
pzbh,pzjlh,je
----------------------
PZH200809270323,59,44
PZH200809270323,59,33
PZH200809270323,59,22这是我删除的数据,可是对应的cwgl_tjbb_xj里面的数据没被减少
update cwgl_tjbb_xj set cwgl_tjbb_xj.bqjs=cwgl_tjbb_xj.bqjs-deleted.je,lx='1' from deleted where deleted.je<0 and cwgl_tjbb_xj.pzh=deleted.pzbh表里面的数据
pzbh,pzjlh,je
----------------------
PZH200809270323,59,44
PZH200809270323,59,33
PZH200809270323,59,22这是我删除的数据,可是对应的cwgl_tjbb_xj里面的数据没被减少
update cwgl_tjbb_xj
这不是更新表?
哪来的删除数据?
pzh,bqzj,bqjs
--------------------------
PZH200809270323,231,0
该条数据为
可是对应的cwgl_tjbb_xj里面的数据没被减少
update 这不是更新?
重发一边:update cwgl_tjbb_xj set cwgl_tjbb_xj.bqzj=cwgl_tjbb_xj.bqzj-deleted.je,lx='1' from deleted where deleted.je>=0 and cwgl_tjbb_xj.pzh=deleted.pzbh
update cwgl_tjbb_xj set cwgl_tjbb_xj.bqjs=cwgl_tjbb_xj.bqjs-deleted.je,lx='1' from deleted where deleted.je<0 and cwgl_tjbb_xj.pzh=deleted.pzbh这些数据是:
pzbh,pzjlh,je
----------------------
PZH200809270323,59,44
PZH200809270323,59,33
PZH200809270323,59,22
我deleted表里面的,意思是删除掉的就是update是后出错,没更新 cwgl_tjbb_xj里面的数据