Thread: New to Triggers
View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 07:41 PM
Dave
 
Posts: n/a
Default 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.
Reply With Quote