利用SQL語句創建觸發器，實現能夠及時更新每種產品的庫存數量

CREATE TRIGGER [TRIGGER NAME] ON [dbo].[TableName]

FOR INSERT

AS

update 庫存表 set 存倉=存倉+數量

CREATE TRIGGER [TRIGGER NAME] ON [dbo].[TableName]

FOR UPDATE

AS

update 庫存表 set 存倉=存倉-temp.數量+數量

CREATE TRIGGER [TRIGGER NAME] ON [dbo].[TableName]

FOR DELETE

AS

update 庫存表 set 存倉=存倉-數量