Need help with an update trigger

[ghost2]

Can anyone give me the followin example for a trigger? I need to update a Last Modification Date in a table if any of four fields change values in that table. The value has to be different from the current value though in order for the trigger to fire. The ID is called SID in the table. Thanks all.

 

[jpicks]

Below is an example of a trigger that I use to datestamp a table any time that any column in the table is updated. If you add a WHERE clause that compares the values of the column in TableName to INSERTED, you should be able to get what you need.

CREATE TRIGGER TableName_DateStampModifyDate
ON DbName.DBO.TableName
FOR UPDATE 
AS 
BEGIN
 UPDATE TableName
 SET MODIFYDATE = getDate()
 FROM TableName T INNER JOIN INSERTED I ON T.ID = I.ID
END

Good luck!