标记应在SQL Server中触发之前或之后使用

由 发布于

I have a column SLTag, data type is bit, and another column SLFile with a data type of VARBINARY(MAX).

When web application is calling to update this table, my trigger shall update SLTag = 1 when SLFile has data, reversely, update SLTag = 0 when SLFile is emptied.

    /*
        Purpose: Trigger update SLTag to 1 when SLFile is not null
    */

    CREATE TRIGGER [SLTag_UPDATE] 
    ON [Employee] 
    AFTER UPDATE
    AS
        DECLARE @EMPLOYEEID AS INT;
    BEGIN
        SET NOCOUNT ON;

        SELECT @EMPLOYEEID = EmployeeId 
        FROM inserted

        UPDATE EMPLOYEE 
        SET SLTag = CASE 
                       WHEN LEN(SLFile) > 0 THEN 1
                       ELSE 0
                    END
        WHERE EmployeeId = @EMPLOYEEID
    END
    GO

    ALTER TABLE [dbo].[Employee] ENABLE TRIGGER [SLTag_UPDATE]
    GO

My question here is: is it appropriate to write the trigger this way? Or I shall write the trigger using instead of?