从SQL Server中的更新操作中获取上次更新的列

-- 创建一个示例表
CREATE TABLE Employee (
    ID INT PRIMARY KEY,
    Name VARCHAR(50),
    Salary DECIMAL(10, 2)
);

-- 插入一些示例数据
INSERT INTO Employee (ID, Name, Salary)
VALUES (1, 'John Doe', 5000),
       (2, 'Jane Smith', 6000);

-- 更新数据
UPDATE Employee
SET Salary = 7000
WHERE ID = 1;

-- 获取上次更新的列
SELECT D.Name AS PreviousName, I.Name AS CurrentName, D.Salary AS PreviousSalary, I.Salary AS CurrentSalary
FROM Employee AS D
JOIN Employee AS I ON D.ID = I.ID
WHERE D.ID = 1;