MSSQL触发器以更改记录中的列值

这是我的写法：

CREATE TRIGGER [dbo].[TriggerClosureAction] ON [dbo].[Actions] AFTER UPDATE,DELETE AS

UPDATE t
SET [Status] = 0
FROM dbo.Tickets As t
-- update only records effected from the current operation
INNER JOIN DELETED As d
    ON t.TicketNumber = d.IdTicket 

-- No records left for that ticket number with status 1 in the actions table
    WHERE NOT EXISTS
    (
        SELECT 1
        FROM Actions As A
        WHERE A.IdTicket = t.TicketNumber
        AND A.[Status] <> 0
    )

更新使用连接到票表deleted表，以确保只有相关的记录被更新-因为deleted表包含了所有来自受影响的记录delete或update触发触发器，那里没有留下记录，如果该语句actions表，其中status不是0-由于这是一个触发器，因此actions表中的数据已经反映了触发该触发器的语句的结果。