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.
Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!