SQL Server 2016 and Azure SQL Database both ... so your Alter Table looks like this: Alter Table dbo.Customers Add PERIOD FOR SYSTEM_TIME (StartTime, EndTime), StartTime datetime2 GENERATED ALWAYS AS ...

SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of the history ... can't guarantee the order in which you'll get your rows. In fact, the default order seems ...