SQL Server 2019 (Linux)

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Employee (
    EmployeeID INT PRIMARY KEY,
    FirstName NVARCHAR(50),
    LastName NVARCHAR(50),
    Salary DECIMAL(10, 2)
);

INSERT INTO Employee (EmployeeID, FirstName, LastName, Salary)
VALUES
    (1, 'John', 'Doe', 50000.00),
    (2, 'Jane', 'Smith', 60000.00),
    (3, 'Michael', 'Johnson', 55000.00);
3 rows affected

SELECT * FROM Employee


EmployeeID
FirstName
LastName
Salary


1
John
Doe
50000.00

2
Jane
Smith
60000.00

3
Michael
Johnson
55000.00


CREATE TABLE SalaryChangeLog (
	LogID INT IDENTITY(1, 1) PRIMARY KEY
	,EmployeeID INT
	,OldSalary DECIMAL(10, 2)
	,NewSalary DECIMAL(10, 2)
	,ChangeTimestamp DATETIME
	);

-- Perform the salary update with the OUTPUT clause
UPDATE Employee
SET Salary = Salary * 1.10 -- 10% salary raise
OUTPUT Deleted.EmployeeID
	,Deleted.Salary AS OldSalary
	,Inserted.Salary AS NewSalary
	,GETDATE()
INTO SalaryChangeLog
WHERE Salary < 60000.00;
2 rows affected

SELECT * FROM Employee


EmployeeID
FirstName
LastName
Salary


1
John
Doe
55000.00

2
Jane
Smith
60000.00

3
Michael
Johnson
60500.00


SELECT * FROM SalaryChangeLog


LogID
EmployeeID
OldSalary
NewSalary
ChangeTimestamp


1
1
50000.00
55000.00
2023-08-13 00:32:48.477

2
3
55000.00
60500.00
2023-08-13 00:32:48.477

LogID	EmployeeID	OldSalary	NewSalary	ChangeTimestamp
1	1	50000.00	55000.00	2023-08-13 00:32:48.477
2	3	55000.00	60500.00	2023-08-13 00:32:48.477