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
Answer:A
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
Explanation: The correct answer is Add a DATETIME column to the table and write a trigger that sets its value.