|
Gerald30
Starting Member
Philippines
46 Posts |
Posted - 10/11/2012 : 22:50:58
|
Hello again.
How can I create an update trigger in which when I update table 1 it will also update Table 2.
Lets say I have 2 Tables. Table 1 with columns ID, Employee_ID, Name and Age. Table 2 with columns ID, Employee_ID, Name and City.
If I will update one record in Table 1 it will also do the update in Table 2.
Also a delete trigger.
Please help me I`m not yet familiar in using MSSQL.
Thank you |
|