4 ms·
It looks like SQL Server 2016 has it as well. They call them Temporal Tables. https://msdn.microsoft.com/en-us/library/dn935015.aspx https://msdn.microsoft.com
by vyrotek 10y ago
It looks like SQL Server 2016 has it as well. They call them Temporal Tables.
https://msdn.microsoft.com/en-us/library/dn935015.aspx https://msdn.microsoft.com/en-us/library/dn935015.aspx
- dspillett 10y agoA feature that made it to standard edition too, unlike CDC and related which were Enterprise only, which is nice. Similar support can be found in quite a few places. It is in the SQL:2011 standard: https://en.wikipedia.org/wiki/SQL:2011 https://en.wikipedia.org/wiki/SQL:2011
- mjibson 10y agoAh, I didn't know that. It looks like you have to enable those explicitly. CockroachDB built time travel over it's existing MVCC layer, which means it works out of the box for all tables.