Temporal Tables

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

Comments

Popular posts from this blog

DotNet CLI

Switch Expressions

sp_executesql