你需要使用 inserted 视图:
inserted
CREATE TRIGGER delete AFTER INSERT ON purchase BEGIN UPDATE In_SHOP SET HMGIS= HMGIS-1 FROM inserted i WHERE IN_SHOP.SHOP_ID = i.SHOP_ID AND IN_SHOP.GAME_ID = i.ID_GAME; END;
你特意问了一下 WHERE 条款。这通常是用来写的 JOIN :
WHERE
JOIN
CREATE TRIGGER delete AFTER INSERT ON purchase BEGIN UPDATE s SET HMGIS = HMGIS - 1 FROM IN_SHOP s JOIN inserted i ON s.SHOP_ID = i.SHOP_ID AND s.GAME_ID = i.ID_GAME; END;