First Look at System-Versioned Temporal Tables-Part 1: Creating Tables and Modifying Data
SQL ServerFirst Look at System-Versioned Temporal Tables-Part 1: Creating Tables and Modifying DataFirst Look at System-Versioned Temporal Tables-Part 1: Creating Tables and Modifying Data
This article is the first in a two-part series that focuses on the ability to keep and query both current and past states of deleted and updated rows in the long run. With system versioning enabled for a table, SQL Server keeps both the current and the past states of modified rows. New query clauses allow you to request to see the data correct to a specified time, or even a specified period.
.jpg?width=100&auto=webp&quality=80&disable=upscale "Picture of Richard Hay")
Editor's Choice
Featured Technical Explainers
Recent What Is
.jpg?width=700&auto=webp&quality=80&disable=upscale)
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.