Can someone give me the basic framework on how to construct a trigger. These are my requirements:
1.) There are 2 tables with the same kind of information.
2.) The 2 tables are linked by a foreign key
3.) When there is a change / update in one of the tables, the same record in the other table must be updated (one way change only).
4.) What is the basic framework of the trigger syntax?
5.) Where should I write / store the trigger in MS Sql Server?