472,132 Members | 1,383 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,132 software developers and data experts.

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 1535
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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.