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 […]

Temporal tables are a little trickier to work with than regular tables in SQL Server. When altering the table structure, you have to first disable versioning. If you’re new to temporal tables, check out my previous post. View code on GitHub

If you have an existing table in SQL Server, and you want to add a history table, here are some steps you can follow. If you’re new to temporal tables, check out my previous post. View code on GitHub

If you need to add records to an existing temporal table in SQL Server, and you need to manipulate the row start column, then you’ll have to do some extra work. If you’re new to temporal tables, check out my previous post. View code on GitHub