SQL触发器在存放在哪个位置

Question

如题所述

Answer 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")