Temporal Tables

Posted by Joe Enos on February 10, 2021 · 1 min read

In the past, you needed triggers and custom tables set up to keep a history of changes in table data - or you had to manually write the history in stored procs.

With temporal tables, SQL Server does all the work for you. There are several ways to get this going, other than what's in the video. This is a fantastic read on the subject where you can see other ways to set things up.

View code on GitHub