Temporal Tables - Historia zmian w SQL Server

query1.sql

CREATE TABLE dbo.Products   
(    
  [Id] int IDENTITY(1,1) PRIMARY KEY,
  [Name] nvarchar(250) NOT NULL,
  [Description] varchar(max) NULL, 
  [ValidFrom] datetime2 (2) GENERATED ALWAYS AS ROW START,  
  [ValidTo] datetime2 (2) GENERATED ALWAYS AS ROW END,  
  PERIOD FOR SYSTEM_TIME (ValidFrom, ValidTo)  
 )    
 WITH (SYSTEM_VERSIONING = ON (HISTORY_TABLE = dbo.ProductsHistory));  

query2.sql

CREATE TABLE dbo.Products   
(    
  [Id] int IDENTITY(1,1) PRIMARY KEY,
  [Name] nvarchar(250) NOT NULL,
  [Description] varchar(max) NULL
 ); 

ALTER TABLE dbo.Products
    ADD ValidFrom datetime2(0)
		GENERATED ALWAYS AS ROW START NOT NULL
        DEFAULT SYSUTCDATETIME(),
    ValidTo datetime2(0)
		GENERATED ALWAYS AS ROW END NOT NULL
        DEFAULT CAST('9999-12-31 23:59:59.9999999' AS datetime2),
    PERIOD FOR SYSTEM_TIME (ValidFrom, ValidTo)
  ALTER TABLE dbo.Products
    SET (SYSTEM_VERSIONING = ON (HISTORY_TABLE = dbo.ProductsHistory))

query3.sql

INSERT INTO dbo.Products (Name, Description) VALUES ('Product Name', 'Product Description');

query4.sql

 UPDATE dbo.Products SET Name = 'Updated Product Name' WHERE Id = 1;

query5.sql

 DELETE FROM dbo.Products WHERE Id = 1;

query6.sql

 SELECT * From dbo.Products 
 FOR SYSTEM_TIME AS OF '2019-02-25 07:59:00.00'
 WHERE Id = 1 
 SELECT * From dbo.Products 
 FOR SYSTEM_TIME AS OF '2019-02-25 08:01:00.00'
 WHERE Id = 1 

query7.sql

 SELECT * From dbo.Products 
 FOR SYSTEM_TIME FROM '2019-02-25 07:59:00.00' TO '2019-02-25 08:01:00.00'
 WHERE Id = 1  

query8.sql

 SELECT * From dbo.Products 
 FOR SYSTEM_TIME ALL
 WHERE Id = 1