create trigger test on WZRK
for update
as
if exists(select * from inserted where 状态=-1)
update WZKC set 库存=库存+I.入库数量 from WZKC W JOIN inserted I
ON W.编号=I.编号 and W.仓库编号=I.仓库编号
for update
as
if exists(select * from inserted where 状态=-1)
update WZKC set 库存=库存+I.入库数量 from WZKC W JOIN inserted I
ON W.编号=I.编号 and W.仓库编号=I.仓库编号
CSDN一号机器人