Microsoft SQL Server Temporal Tables Return actual value specified point in time(FOR SYSTEM_TIME AS OF )


Example

Returns a table with a rows containing the values that were actual (current) at the specified point in time in the past.

SELECT * FROM Employee   
    FOR SYSTEM_TIME AS  OF '2016-08-06 08:32:37.91'