12. Views, triggers and temporary objects

CREATE OR ALTER VIEW dbo.vw_ActiveEmployees WITH SCHEMABINDING AS
SELECT EmpId, FullName, DeptId FROM dbo.Employees WHERE IsActive = 1;
-- Indexed (materialised) view: SCHEMABINDING + unique clustered index

CREATE OR ALTER TRIGGER dbo.trg_Employees_Audit ON dbo.Employees
AFTER UPDATE AS
BEGIN
    SET NOCOUNT ON;
    INSERT INTO dbo.SalaryAudit (EmpId, OldSalary, NewSalary, ChangedAt)
    SELECT d.EmpId, d.Salary, i.Salary, SYSUTCDATETIME()
    FROM inserted i JOIN deleted d ON d.EmpId = i.EmpId
    WHERE i.Salary <> d.Salary;            -- handle MULTI-ROW updates, not just one row
END;