How to handle existing data while enabling versioning on existing table?
Question:
I am trying to enable system versioning to an existing table like this
ALTER TABLE [dbo].[User]
ADD ValidFrom DATETIME2 GENERATED ALWAYS AS ROW START,
ValidTo DATETIME2 GENERATED ALWAYS AS ROW END,
PERIOD FOR SYSTEM_TIME (ValidFrom, ValidTo...
databasedev.hashnode.dev2 min read