Introduction to Temporal Tables
Application & Database Development
Many times developers have to support users by answering the “What happened to the data?” The task of retrieving data from a specific point in time is not an easy one. Often this involves retrieving a backup and restoring the data in question (hopefully!). SQL Server 2016 introduced Temporal Tables, allowing a developer to retrieve data from a specific point in time, without backups. With a few TSQL commands a historical table can be created, automatically updated, and readily accessed.