CREATE TRIGGER trg_update_yourtable
SET date_modified = GETDATE()
FROM yourtable t
JOIN INSERTED i
ON t.primary_key_field = i.primary_key_field
AND t.date_modified < GETDATE()
Open in new window
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.