sql server 2008 触发器放在哪

2025-03-23 09:51:39
推荐回答(1个)
回答1:

放在需要触发条件的表下面,例如下面的on后面跟的[dbo].[A01]就是给哪个表触发
ALTER TRIGGER [dbo].[A01_UPDATE_A815]
ON [dbo].[A01]
AFTER UPDATE
AS
BEGIN

SELECT A0188 INTO #A0188 FROM INSERTED

IF UPDATE ("A0191") OR UPDATE ("EXT072")