How to write a TRIGGER?
-
Hi, When I update a Particular row with some value in sql table(letus consider Emp1) that row should be inserted inot another table (consider Emp2) and should be deleted from Emp1. For this I want to write a Trigger.......How..? Exact requirement:: I have Emp1(Id,Name,Desig) table. When I update a particualr row where Id='3' Then only..... 1.Particular row which is update with Id value '3' should be inserted into the Emp2(Id,Name,Desig) table. And 2. After inserting into the Emp2 The row should be deleted from Emp1. Thanking you McMilan.
-
Hi, When I update a Particular row with some value in sql table(letus consider Emp1) that row should be inserted inot another table (consider Emp2) and should be deleted from Emp1. For this I want to write a Trigger.......How..? Exact requirement:: I have Emp1(Id,Name,Desig) table. When I update a particualr row where Id='3' Then only..... 1.Particular row which is update with Id value '3' should be inserted into the Emp2(Id,Name,Desig) table. And 2. After inserting into the Emp2 The row should be deleted from Emp1. Thanking you McMilan.
Wrong forum, you could ask it better in the sql forum :) But before that search it in google, Its not that much difficult. :)
EVEN THE WORD IMPOSSIBLE SAYS I M POSSIBLE.