>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. >ENDFUNC >>SQL 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 >