SQL Server 2016 introduces a new feature called Temporal tables/ System versioned temporal tables which helps us in performing point in time analysis, data auditing and repairing Row-Level Data Corruption. In this lab, we will learn about temporal tables. In the first exercise, we will learn to create and query the system versioned temporal tables. In the second exercise, we will learn to change the schema of the temporal tables. In third exercise, we will learn the internals of temporal table data retrieval process.

Subscribe to Download


Version1.0
Download1
File Size930.46 KB
Create DateMarch 30, 2017
Last UpdatedMarch 30, 2017
Delete vs Truncate in SQL Server
Temporal Tables in SQL Server 2016 Part 2