Category: SQL Server MCQs

You want to track date and time of the last write access per row?

administrator
You want to track date and time of the last write access per row?
Add TIMESTAMP column to the table
Well Done. Your Answer is Correct Keep it Up!
Add a DATETIME column to the table and assign getdate() as the default value
Add a DATETIME column to the table and write a trigger that sets its value
Add a UNIQUEIDENTIFIER column to the table and use it with SQL Server’s built-in functions
Page 2 of 3
1 2 3