SQL Server Temporal Tables: How-To Recipes

added by DotNetKicks
2/13/2017 3:21:38 PM

1 Kicks, 273 Views

Tables that return the value of the data in the table at a particular point of time have been with us since the first relational database, but have always required special queries and constraints, and can be tricky to get right. System-versioned Temporal Tables, new in SQL Server 2016, make such tables behave like any other.