SQL: A Beginner's Guide, Fourth Edition, 4th Edition

Chapter 13

Working with Temporal Data

Key Skills & Concepts

    Create and Use System-Versioned Tables

    Create and Use Application-Time Period Tables

    Create and Use System-Versioned Application-Time Period Tables

 

In this chapter, I discuss the temporal features that were added to the SQL:2011 standard. Temporal data is data that changes over time. In SQL, the term temporal data refers to any data that is defined with one or more associated ...