SQL Server 触发器-如何安全地确定是由UPDATE还是DELETE触发？

CREATE TRIGGER tr_Example
ON YourTable
AFTER UPDATE, DELETE
AS
BEGIN
    DECLARE @Operation VARCHAR(10)

    IF EXISTS(SELECT * FROM deleted) AND EXISTS(SELECT * FROM inserted)
    BEGIN
        SET @Operation = 'UPDATE'
    END
    ELSE IF EXISTS(SELECT * FROM deleted)
    BEGIN
        SET @Operation = 'DELETE'
    END
    ELSE
    BEGIN
        SET @Operation = 'INSERT'
    END

    IF @Operation = 'UPDATE'
    BEGIN
        -- 在此处执行 UPDATE 操作的逻辑
    END
    ELSE IF @Operation = 'DELETE'
    BEGIN
        -- 在此处执行 DELETE 操作的逻辑
    END
    ELSE
    BEGIN
        -- 在此处执行 INSERT 操作的逻辑
    END
END