Advertisement
Aliendreamer

22 from triggers

Jun 20th, 2018
405
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.21 KB | None | 0 0
  1. CREATE TRIGGER tr_DeleteEmployees
  2.   ON Employees
  3.   AFTER DELETE
  4. AS
  5.   BEGIN
  6.     INSERT INTO Deleted_Employees
  7.       SELECT FirstName,LastName,MiddleName,JobTitle,DepartmentID,Salary
  8.       FROM deleted
  9.   END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement