在领料单表tblGetMaterialBody中插入数据时更新产品库存表tblproduct ,inserted是插入的数据构成的临时表
CREATE TRIGGER [IPRODUCT] ON [tblGetMaterialBody]
FOR INSERT
NOT FOR REPLICATION
AS
UPDATE tblproduct SET NUMBER=NUMBER - INSERTED.NUM
from inserted
WHERE tblproduct.nox=inserted.productnox
CREATE TRIGGER [IPRODUCT] ON [tblGetMaterialBody]
FOR INSERT
NOT FOR REPLICATION
AS
UPDATE tblproduct SET NUMBER=NUMBER - INSERTED.NUM
from inserted
WHERE tblproduct.nox=inserted.productnox
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货