I'm converting an app from VFP to SQL Server 2005 and I've just had a stab at converting my first trigger. Any comments on the code I used. The purpose of the trigger is to update a field with the current date, if 1 of 2 fields have changed.

VFP Function called by the record validation event.

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