Trigger for inserting record into another table

mody82 · Jan 26, 2009

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 · Jan 26, 2009

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

Code:

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 · Jan 26, 2009

Thx alooot , I tried it's working nicely

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Trigger for inserting record into another table

mody82

Technical User

JohnDTampaBay

Programmer

mody82

Technical User

Similar threads

Part and Inventory Search

Sponsor