How to Stopping System-Versioning on a System-Versioned Temporal Table in SQL Server 2016?
How to Stopping System-Versioning on a System-Versioned Temporal Table in SQL Server 2016?
回答1
My problem was solved when i using following query:
-- SET SYSTEM_VERSIONING TO OFF
ALTER TABLE [dbo].[MyTable]
SET (SYSTEM_VERSIONING = OFF)
GO
** Do what ever you want to **
-- SET SYSTEM_VERSIONING TO ON
ALTER TABLE [dbo].[MyTable]
SET
(SYSTEM_VERSIONING = ON (HISTORY_TABLE = [dbo].[MyTable_Archive] , DATA_CONSISTENCY_CHECK = ON ))
GO