我的方法:

• 在 ModDate 列上定义一个 默认约束，值为 GETDATE() - 这将处理 INSERT 案例

• define a default constraint on the ModDate column with a value of GETDATE() - this handles the INSERT case

有一个 AFTER UPDATE 触发器来更新 ModDate 列

have a AFTER UPDATE trigger to update the ModDate column

类似于:

CREATE TRIGGER trg_UpdateTimeEntry
ON dbo.TimeEntry
AFTER UPDATE
AS
    UPDATE dbo.TimeEntry
    SET ModDate = GETDATE()
    WHERE ID IN (SELECT DISTINCT ID FROM Inserted)