You want to track date and time of the last write access per row?
(a) Add TIMESTAMP column to the table
(b) Add a DATETIME column to the table and assign getdate() as the default value
(c) Add a DATETIME column to the table and write a trigger that sets its value
(d) Add a UNIQUEIDENTIFIER column to the table and use it with SQL Server’s built-in functions
I got this question in quiz.
This key question is from Data Types in chapter Laying the Foundation of SQL Server