Microsoft SQL Server Temporal Tables FOR SYSTEM_TIME ALL


Example

Returns the union of rows that belong to the current and the history table.

SELECT * FROM Employee
    FOR SYSTEM_TIME ALL