1. counton,实现能够及时更新每种产品的库存数量?
分别增加三个触发器对应INSERT, UPDATE, DELETE CREATE TRIGGER [TRIGGER NAME] ON [dbo].[TableName] FOR INSERTASupdate 库存表 set 存仓=存仓+数量CREATE TRIGGER [TRIGGER NAME] ON [dbo].[TableName] FOR UPDATEASupdate 库存表 set 存仓=存仓-temp.数量+数量CREATE TRIGGER [TRIGGER NAME] ON [dbo].[TableName] FOR DELETE ASupdate 库存表 set 存仓=存仓-数量