New to Triggers I'm trying to get a grasp on triggers, and that brings me here. I
have a series of tables with a 'Modby' field and a 'ModDate' field.
In the Default Value Property I have the (suser_sname()) and
(GetDate()) functions. Is what I'm after is a trigger that will
update these fields, for a specific record, if/when the record has
been modified.
I appreciate your help, and Thanks in advance. |