Sql Update Trigger
-
Hello everyone, I need ur help to write a trigger. I have 3 tables (Ex: Employee master,Employee salary details and Employee in_out details),if i update any value in the Employee master table, the value must be automatically updated in other related tables. Plzzzzzzzzzz help urgent!!!!!! Thanks.
-
Hello everyone, I need ur help to write a trigger. I have 3 tables (Ex: Employee master,Employee salary details and Employee in_out details),if i update any value in the Employee master table, the value must be automatically updated in other related tables. Plzzzzzzzzzz help urgent!!!!!! Thanks.
Jesu Prabhu.J wrote:
Plzzzzzzzzzz help urgent!!!!!!
Not, its not urgent.
Jesu Prabhu.J wrote:
I need ur help to write a trigger.
So write your version and if it doesn't work post it and someone will help. A clue, you need a trigger on Employee for insert and update which will select the values from the inserted table and update the other two tables. There you go, now google triggers.
Bob Ashfield Consultants Ltd
-
Jesu Prabhu.J wrote:
Plzzzzzzzzzz help urgent!!!!!!
Not, its not urgent.
Jesu Prabhu.J wrote:
I need ur help to write a trigger.
So write your version and if it doesn't work post it and someone will help. A clue, you need a trigger on Employee for insert and update which will select the values from the inserted table and update the other two tables. There you go, now google triggers.
Bob Ashfield Consultants Ltd
I am using SQL Server 2000, If i change any value Ex: Employee Name in the (Employee Master) the value Employee Name must get updated in the other 2 tables.. Thanks for the Reply..
-
I am using SQL Server 2000, If i change any value Ex: Employee Name in the (Employee Master) the value Employee Name must get updated in the other 2 tables.. Thanks for the Reply..
Jesu Prabhu.J wrote:
I am using SQL Server 2000, If i change any value Ex: Employee Name in the (Employee Master) the value Employee Name must get updated in the other 2 tables..
Yes, I assumed you were using SQL Server. You still need a trigger on Employee Master. There are hundreds of examples on Google.
Bob Ashfield Consultants Ltd