AFTER UPDATE Trigger in SQL Server

AFTER triggers can be used to fire after updating a table. It can be used to make decisions based on the values being updated.Consider the following table:CREATE TABLE emp(empid varchar(10), salary decimal(12,2)) GOINSERT INTO emp(empid,salary)SELECT 'EMP01',20000 union allSELECT 'EMP02',16700 union allSELECT 'EMP03',2000 union allSELECT 'EMP04',2800.45 union allSELECT 'EMP05',50000 GOSuppose you