krunal jagani
Reputation: 21
Temporal table like functionality for SQL server 2014 or older version
Is it possible to create temporal table kind of a functionality to keep history of frequently changing records in SQL server 2014 or older versions. I need to track historical changes in a table (E.g, part X was out of stock for Y number of days in Z period in Inventory table given part number and the date when it is received)
Upvotes: 1
Views: 153
Answers (0)
Related Questions
- How do I create a temporal table in SQL Server 2016?
- Temporal Table : specific column changed version details only
- Why we require temporal table in SQL Server 2016 as we have CDC or CT?
- Variable History_Retention_Period for SQL Server System Versioned Tables
- How to identify changed values using a SQL Server temporal table?
- Is it possible to use system-versioned temporal table in the fact-dimension DWH design?
- Trying to validate if a SQL Server data model uses temporal tables?
- SQL Server : convert historical data to Temporal Tables
- Temporal extensions to SQL Server
- ms sql temporal table find history on column where last changed