Temporal Tables

External Article

Getting Started with Temporal Table in SQL Server 2016 – Part 1

  • Article

With the new temporal table feature, SQL Server 2016 internally manages two tables: a base table, which contains the latest data all the time, and a history table, which contains a history of all of the changes. Arshad Ali looks at the new feature, how it works, and how to either create a new table with this feature or enable it for an existing table.

2016-04-11

4,139 reads

Blogs

Ramblings about data communities and your contributions, no excuses

By

I have been active in the data community throughout my career. I have met...

SQL Server Journey till 2025 (brief)

By

Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...

Building Power BI Reports: Desktop vs Fabric

By

Why this comparison feels confusing If you’re a Power BI report author who’s just...

Read the latest Blogs

Forums

Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE

By DanielP

Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...

Having a Little Fun at SQL Server Central

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Having a Little Fun at...

Designing SQL Server Pipelines That Are Ready for AI Before You Actually Need AI

By Ankush Rastogi

Comments posted to this topic are about the item Designing SQL Server Pipelines That...

Visit the forum

Question of the Day

String Similarity I

On SQL Server 2025, when I run this, what is returned? 

SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL')

See possible answers