SQL - Row Update Trigger

RowModifiedTrigger.sql

-- Add the Modified field to the row
-- E.g. Add a column to the table using a create/alter statement like:
-- ...
-- Modified DATETIME2(3),
-- ...
-- Then create the trigger

CREATE TRIGGER updateModified
ON dbo.YourTable
AFTER UPDATE 
AS
   UPDATE dbo.YourTable
   SET modified = SYSDATETIME()
   FROM Inserted i
   WHERE dbo.YourTable.PrimaryKey = i.PrimaryKey