Trigger for inserting record into another table

[mody82]

Dear all;
I need a trigger which allow me to delete record from Table_1 and insert it to Table_2 ?
Means that I have two tables , one for current employees and the other for previous employees , So when I delete the employee from the Table_1 Should be inserted to Table_2 ...
>> Hope it's Clear <<

 

[JohnDTampaBay]

Assuming TAble_1 and Table_2 have identical structures, a simple trigger would be ...

CREATE TRIGGER trg_Table1_Delete
ON Table_1
AFTER DELETE AS 
  INSERT INTO Table_2 SELECT * FROM Deleted

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[mody82]

Thx alooot , I tried it's working nicely