sqlserver创建一个触发器,当供应表增加一条记录时,物资表的相应物资的库存量 增加 供应数量GYnum。
时间: 2024-05-28 19:15:32 浏览: 18
好的,这个问题属于技术问题,可以回答。触发器代码如下:
CREATE TRIGGER trig_update_inventory
ON supply_table
AFTER INSERT
AS
BEGIN
UPDATE inventory_table
SET stock = stock + inserted.GYnum
FROM inventory_table
INNER JOIN inserted ON inserted.WZID = inventory_table.WZID
END
相关推荐
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![text/plain](https://img-home.csdnimg.cn/images/20210720083646.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)