H-SC
asked on
Update trigger GetDate() on Indexed
I have a table with a DateTime field called "stamp". The default value is already set for (GetDate()) on insert of new records and wrks fine.
I need that "stamp" field to get updated with GetDate() when that particular record/index is updated.
How can this be done. I would prefer not to use any history/temp table method here.
I need that "stamp" field to get updated with GetDate() when that particular record/index is updated.
How can this be done. I would prefer not to use any history/temp table method here.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect! Many thanks.