text: CREATE TABLE Deleted_Employees
  (
  	EmployeeId INT PRIMARY KEY IDENTITY,
  	FirstName VARCHAR(50) NOT NULL,
  	LastName VARCHAR(50) NOT NULL,
  	MiddleName VARCHAR(50),
  	JobTitle VARCHAR(50),
  	DepartmentId INT,
  	Salary DECIMAL(15, 2)
  )
  
  CREATE TRIGGER tr_DeleteEmployees
    ON Employees
    AFTER DELETE
  AS
    BEGIN
      INSERT INTO Deleted_Employees
        SELECT
          FirstName,
          LastName,
          MiddleName,
          JobTitle,
          DepartmentID,
          Salary
        FROM deleted
  END