Trigger for inserting record into another table
Trigger for inserting record into another table
(OP)
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 <<
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 <<
RE: Trigger for inserting record into another table
CODE
ON Table_1
AFTER DELETE AS
INSERT INTO Table_2 SELECT * FROM Deleted
--John![[rainbow] rainbow](https://www.tipmaster.com/images/rainbow.gif)
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)
RE: Trigger for inserting record into another table