Chapter 13

Working with Temporal Data

Key Skills & Concepts

Images    Create and Use System-Versioned Tables

Images    Create and Use Application-Time Period Tables

Images    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 ...

Get SQL: A Beginner's Guide, Fourth Edition, 4th Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.