SQLSERVER 触发器记录表某个字段更新记录

想要记录该字段的原值和现有值，触发器写法：

CREATE TRIGGER tr_UpdateEmployeeDepartment
ON Employees
AFTER UPDATE
AS
BEGINSET NOCOUNT ON; -- 避免多余的计数消息IF UPDATE(Department) -- 检查是否更新了 Department 字段BEGININSERT INTO UpdateLog (EmployeeID, FieldName, OldValue, NewValue)SELECTinserted.EmployeeID,'Department',deleted.Department,inserted.DepartmentFROMinsertedINNER JOINdeleted ON inserted.EmployeeID = deleted.EmployeeID;END
END;