469,167 Members | 2,084 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,167 developers. It's quick & easy.

how to write a trigger after insert

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.......
Jun 9 '11 #1
1 1503
2,878 Expert 2GB
Post what you have so far, and we'll see what we can do to help.

~~ CK
Jun 9 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

8 posts views Thread by Jason | last post: by
6 posts views Thread by Scott CM | last post: by
1 post views Thread by ajay.sonawane | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.