MS SQLServer Trigger

为，当某个字段改变的时候，作处理
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER TRIGGER [trg_work_petition_update] ON [dbo].[work_petition]
FOR UPDATE
AS
BEGIN
    DECLARE @wrk_p_cd INT,
            @wrk_endflag2 INT
    IF  UPDATE(endflag2)
    BEGIN
        SELECT  @wrk_endflag2 = endflag2 
          FROM  INSERTED
        IF  (@wrk_endflag2 = 2)
        BEGIN
            SELECT  @wrk_p_cd = p_cd  
              FROM  INSERTED
         
        END
    END
 
END