sql server insert where clauses

Question

0.00/5 (No votes)

See more:

when creating a insert what is the rule

insert ps.pid, ps.tid, b.bpid into person p, pros ps, bid b 
where p.pid = ps.pid 
and p.bpid = b.bpid 
and ps.pid = b.bpsid

so does the insert direction goes pros id insert into person id then bid insert into person then bid insert into pros

or the reverse

I have a list of data with id numbers created.

pros are 1 to 10
bid are 1 to 10
person are 1 to 10

the bid table has a fk of pros
the person table has a fk of pros and bid

what I need to happen is when I do a insert for the

person table that it receive the pros and the bid fk id

sample query would be nice.

Posted 12-Oct-10 6:35am

postonoh

Updated 12-Oct-10 7:03am

v3

Add a Solution

Comments

AspDotNetDev 12-Oct-10 16:16pm

What in the world are you talking about? You can only insert into one table at a time, and if that is SQL you are attempting to write the syntax is all wrong. And why do you create line breaks for no apparent reason? This question is unreadable. Tidy it up a bit and try to get your question across clearly and we may be able to help.

postonoh 12-Oct-10 16:47pm

I understand that first one table is updated then from the table an id is inserted into the second then third and so on.

I guess the question I am asking is what order do I have to write it.

I asking the order of insert when writing the query is it

right to left table1 insert into table2
right to left table2 insert into table3
right to left table1 insert into table3

2 solutions

Solution 2

we do not use where clause with insert statement

Posted 12-Oct-10 19:47pm

Jipin

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)

Steve Wellens · Accepted Answer · 2010-10-12T12:27:00

You do not use a WHERE clause with an INSERT statement.

INSERT creates a brand new record unrelated to the existing records. The indexes will be updated automatically so the record will be sorted correctly in relation to the existing records.

For foreign key related tables, you must insert the parent record first. Otherwise, what key would you give to the child records since the parent doesn't exist yet?