Performing Data Changes Audit Using Temporal Table

Jim Lorinser
Aug 30 2018
Resource

0
0
2.7k

SQL Server 2016 has introduced a feature called ‘System versioned temporal table’. Using a normal table, you can retrieve current data; while using a system-versioned temporal table, you can retrieve data which was deleted or updated in the past. To do that, a temporal table will create a history table. The history table will store old data with “start_time” and “end_time”. Which indicates a time period for which the record was active.

Learn More >>