track date and time of the last write access
You want to track date and time of the last write access (INSERT, UPDATE) per row. How can you achieve that?
Select Answer:
1. Add a TIMESTAMP column to the table; SQL Server will automatically track date and time of every change.
2. Add a DATETIME column to the table and assign getdate() as the default value.
3. Add a DATETIME column to the table and write a trigger that sets its value
4. Add a UNIQUEIDENTIFIER column to the table and use it with SQL Server's built functions.
|