Trigger - After Delete Examples
CREATE TRIGGER trgPFPAmountLog
ON [dbo].[t_PfpAmount]  
AFTER DELETE 
AS 
      INSERT INTO t_PfpAmount_Log
      (
            LocationID,[Month],[Year],
            EmpID,PFPAmount,[System],
            CreatedBy,CreatedOn,
            DBLoginName,SystemIP
      )  
     
      SELECT
                  LocationID,[Month],[Year],
                  EmpID,PFPAmount,[System],CreatedBy,
                  CreatedOn,SYSTEM_USER ,HOST_NAME()
      FROM deleted

05:09 | Category: | 0 comments

Comments (0)

Post a Comment