4 ms·
MS SQL server 2016 onwards has temporal tables that support this (point in time data)
by tthun 6y ago
MS SQL server 2016 onwards has temporal tables that support this (point in time data)
- joshspankit 6y agoHuh. I just read the spec. Not quite three 'dimension', but looks like exactly what I was asking for: a (reasonably) automatic and transparent record of previous values, as well as timestamps for when they changed. I'll call this a "you learn something every day" and a "hey thanks @tthun (and @predakanga)"