Temporal tables

- System version tables
- Point-in-time data access
- Behind the hood: a history table is created with the same schema, but without constraints
- ALTER TABLE automatically updates the history table

DECLARE @TenDaysAgo datetime2 = DATEADD(d, -10, SYSDATETIME())

SELECT *
FROM dbo.MyTable
FOR SYSTEM_TIME AS OF @TenDaysAgo

Is this useful?