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.