You want to track date and time of the last write access per row. Select the suitable option among the below.

Question

Admin · Accepted Answer

Add TIMESTAMP column to the table

Admin · Answer

Add a DATETIME column to the table and assign getdate() as the default value

Admin · Answer

Add a DATETIME column to the table and write a trigger that sets its value

Admin · Answer

Add a UNIQUEIDENTIFIER column to the table and use it with SQL Server&rsquo;s built-in functions

Q. You want to track date and time of the last write access per row. Select the suitable option among the below.