我的方法：

• 在 ModDate $上定义默认约束 c $ c>列，值为 GETDATE（） - 这将处理 INSERT 案例




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

  CREATE TRIGGER trg_UpdateTimeEntry 
 ON dbo.TimeEntry 
更新后
 AS 
更新dbo.TimeEntry 
 SET ModDate = GETDATE（）
 WHERE ID IN（插入的SELECT DISTINCT ID）
 

It would be nice to know how to create a trigger that auto-updates the modifiedDate column in my SQL Server table:

Table TimeEntry

Id (PK)
UserId (FK)
Description
Time
GenDate
ModDate

Trigger code:

+   TR_TimeEntry_UpdateModDate()
+   TR_TimeEntry_InsertGenDate()

An example for update ModDate would be nice.

Thanks in advance!

Julian

My approach:

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

• have a AFTER UPDATE trigger to update the ModDate column

Something like:

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