FUNCTION dept_rv() SELECT dept IF dept.repdate <> oldval("repdate","dept") OR ; dept.repstaff <> oldval("repstaff","dept") REPLACE dept.repmod WITH date() ENDIF RETURN .T. ENDFUNCSQL Server Update Trigger
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER TRIGGER [Trigger_Dept_Update] on [dbo].[dept] AFTER UPDATE AS IF UPDATE(repdate) or UPDATE(repstaff) BEGIN UPDATE Dept SET repmod = GETDATE() FROM Dept INNER JOIN inserted ON dept.id = inserted.id END