CREATE TRIGGER tr_u_employee ON employee
FOR UPDATE AS
DECLARE @a INT, @b INT, @C INT, @factor INT, @value INT, @columns AS VARCHAR(200), @colname AS VARCHAR(100)
IF ( (SUBSTRING(COLUMNS_UPDATED(),1,1) & 70 > 0))
AFTER UPDATE
ON Employee
FOR EACH ROW
-- Update record into Users table
UPDATE Portsl.dbo.Users
( employee_id,
FirstName,
LastName,
Status )
VALUES
( :old.employee_id,
:new.FirstName,
:new.LastName,
:new.Status );
END;
|