使用触发器标记

Question

BEGIN
    SET NOCOUNT ON;

    IF (UPDATE( HighestDegreeDoc) OR UPDATE (GPA) OR UPDATE (CreditHours))     
    BEGIN
        UPDATE [dbo].[School]
        SET Uploaded = 1
        FROM dbo.School
        JOIN INSERTED i ON i.EmpID = dbo.School.RecID
        END
    RETURN         
END

ALTER TRIGGER [dbo].[TrigEdu]
ON [dbo].[Education]
AFTER UPDATE
AS
BEGIN
    SET NOCOUNT ON;

    IF NOT (UPDATE( HighestDegreeDoc) OR UPDATE (GPA) OR UPDATE (CreditHours))     
    RETURN

    UPDATE [dbo].[School]
    SET Uploaded = 1
    FROM dbo.School
    JOIN INSERTED i ON i.EmpID = dbo.School.RecID
END

这两个代码给了我相同的结果。我只想当这三个字段 更改其中之一，然后更新 School.RecID。但其更新日期与教育表任何领域的任何更新相同。 :(

Answer 1

在更新触发时，您可以访问记录的新版本和旧版本。您已获得新版本“已插入”，只需将其与旧版本“已删除”进行比较即可。

UPDATE dbo.School
SET Uploaded = 1
FROM dbo.School
JOIN INSERTED i ON i.EmpID = dbo.School.RecID
JOIN DELETED d ON d.EmpID = dbo.School.RecID
where i.HighestDegreeDoc != d.HighestDegreeDoc
or i.GPA != d.GPA
or i.CreditHours != d.CreditHours