How to: Create trigger for auto update modified date with SQL Server 2008
My approach:
define a default constraint on the
ModDatecolumn with a value ofGETDATE()- this handles theINSERTcasehave a
AFTER UPDATEtrigger to update theModDatecolumn
Something like:
CREATE TRIGGER trg_UpdateTimeEntryON dbo.TimeEntryAFTER UPDATEAS UPDATE dbo.TimeEntry SET ModDate = GETDATE() WHERE ID IN (SELECT DISTINCT ID FROM Inserted)