보미네

System-Versioned Temporal Tables

CREATE TABLE dbo.Employee
(
    EmpID INT PRIMARY KEY,
    Name NVARCHAR(100),
    Salary INT,
    ValidFrom DATETIME2 GENERATED ALWAYS AS ROW START,
    ValidTo   DATETIME2 GENERATED ALWAYS AS ROW END,
    PERIOD FOR SYSTEM_TIME (ValidFrom, ValidTo)
)
WITH 
(
    SYSTEM_VERSIONING = ON 
    (HISTORY_TABLE = dbo.EmployeeHistory)
);
go



INSERT INTO dbo.Employee (EmpID, Name, Salary)
VALUES (1, 'Kim', 3000);
go

UPDATE dbo.Employee
SET Salary = 4000
WHERE EmpID = 1;
go

DELETE FROM dbo.Employee
WHERE EmpID = 1;
go

SELECT *
FROM dbo.Employee
FOR SYSTEM_TIME ALL
ORDER BY EmpID, ValidFrom;
go

select * from Employee
go

select * from EmployeeHistory
go