Insert operation in sql server

Question

0.00/5 (No votes)

See more:

Dear Memebers,

Help Me out with the one question which one of my friend has asked me

There are two tables table1 and table2

Table1 has two columns
colA --primary key
colB-- foreign key

Table2 has two columns
colB--Primary key
colA--foreign key

Table1's colB is dependent on table2's colB
Table2's colA is dependent on table1's colA

Insert operation is to be performed on these tables

How can we perform this operation?

Posted 11-Jun-12 21:15pm

vikashbk

Add a Solution

2 solutions

Solution 1

This is a bad design, foreign keys should only go one way from child to parent.

Posted 11-Jun-12 21:25pm

Mehdi Gholam

Comments

Sandeep Mewara 12-Jun-12 9:31am

Comment from OP:
Dear Mehdi Gholam,

I know that this is a bad design, but what would be the solution if such kind of problem's occurred.

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)

harshada3 · Accepted Answer · 2012-06-11T21:42:00

Solution 3

INSERT INTO table_1(colA,colB) VALUES (1,null)
INSERT INTO table_2(colB,colA) VALUES (1,1)
UPDATE table_1 SET colB=1 WHERE colA=1

Posted 11-Jun-12 21:42pm

harshada3

Comments

vikashbk 13-Jun-12 2:34am

Thanks Harshada,