How do I insert 1000 rows of data from table 1 to table 2?

Question

0.00/5 (No votes)

See more:

I am trying to insert 1000 rows of data from table 1 to table 2 but table 2 have one additional column which is sequence number ( an extra column) , how can I make that column sequence . please note table 2 already have 500 records.

Posted 2-Apr-14 3:39am

deenasudhakar

Updated 17-Apr-14 18:28pm

v2

Add a Solution

Comments

Maciej Los 2-Apr-14 13:32pm

Please, elaborate what "sequence number" means. Provide sample data and i promise to upgrade my answer.

deenasudhakar 6-Apr-14 6:42am

Thanks for your comment.
Sequence number is like row no.
for example : An organisation have two branches in area 1 and area 2 . They maintain list of employees details in production separately now they need to merge and form single list of employees.

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)

Maciej Los · Answer 1 · 2014-04-02T07:26:00

Solution 2

Solution1 is good, but i strongly recommend to define destination field list.

SQL

insert into tableB (<field_list>)
SELECT <field_list>
FROM tableA

where <field_list> is the list of fields.

Note: The data type for each field must be the same type.

More details here:
Adding Rows by Using INSERT and SELECT[^]
INSERT (sql)[^]

Posted 2-Apr-14 7:26am

Maciej Los

Comments

Abhinav S 2-Apr-14 13:31pm

5.

Maciej Los 2-Apr-14 13:32pm

Thank you, Abhinav ;)

Abhinav S · Answer 2 · 2014-04-02T03:56:00

Solution 1

Try

<br />
insert into tableB<br />
select col1,col2,col3,'' from tableA<br />

where '' represents value for the extra column.

Posted 2-Apr-14 3:56am

Abhinav S

v2

Comments

Maciej Los 2-Apr-14 13:28pm

Good, but it needs some extra information. Please, see my comment.

deenasudhakar 6-Apr-14 6:48am

Thanks Abhinav , but extra column is like row no. which is non identity, then it requires to fill by hand code query. pls see my comment for maciej los