Stored procedures for Parent child tables

Question

0.00/5 (No votes)

See more:

I have two tables. customers(parent) and orders(child).

Customer table looks like

Cid     Name     Address    ProductId
 1        a        b          1
 2        c        d          2

Orders

Oid   productid   productname          cost
1        1        Washing machine      15,000
2        2             TV              8,000

how to write a stored procedure for these two tables? customer is parent table and order is child table. if i insert a data in customer table it should get inserted in child table as well. wat i meant wat ever the changes m gonna make in parent table it should be reflected in child table as well.

Posted 12-Aug-13 21:16pm

ARUN K P

Updated 12-Aug-13 21:18pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

v2

Add a Solution

Comments

Sadique KT 13-Aug-13 3:25am

Product Id in child should be Foreign key.
Insert row to parent table
get max(ProductId), then insert all rows in child with the Product Id retrieved from parent table after insertion of first row in parent table.

ARUN K P 13-Aug-13 3:31am

ok fine

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 13-Aug-13 3:35am

Is your problem solved?

ARUN K P 13-Aug-13 3:36am

yeah tadit.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 13-Aug-13 3:45am

Okay. Great news. As a part of moderation, I have added one answer.

Please accept that and up-vote. We need to change the status of this question as "solved".

Thanks,
Tadit

ARUN K P 13-Aug-13 3:47am

done tadit

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Raja Sekhar S · Accepted Answer · 2013-08-12T21:37:00

Solution 1

I Suggest you to add a Trigger for the Parent Table.. such that it insert records into Child Table...

For Information on Triggers : Triggers MSDN[^]

Comment Given By Sadique is a Valid Point...

Posted 12-Aug-13 21:37pm

Raja Sekhar S

Comments

ARUN K P 13-Aug-13 3:47am

ok fine

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2013-08-12T21:44:00

Solution 2

Just adding one answer on behalf of Sadique KT as the problem got solved.

Quote:
Product Id in child should be Foreign key.

Insert row to parent table.
Get max(ProductId), then insert all rows in child with the Product Id retrieved from parent table after insertion of first row in parent table.

Posted 12-Aug-13 21:44pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

ARUN K P 13-Aug-13 3:52am

ok

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 13-Aug-13 3:58am

:)
Thanks for accepting and up-voting.