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.