how to write a trigger after insert

[javeed]

hi,,,,
i am having three tables(i.e,)employee,department,EDo tables and from that department no is common in all the three tables and when inserting the status should be set for that i have to write the stored procedure and trigger after insert and in sp we have to write update status and select statements.in select statement we have to pass the get the department name from table EDo where dept no is given.(i.e,)from the sp and trigger after insert when i give the department number then it should bring the department name out from the table.......

[ck9663]

Post what you have so far, and we'll see what we can do to help.


~~ CK