How to Copy All Data From one Sql Table To Another in VB.net

Question

0.00/5 (No votes)

See more:

I want to copy all data from one sql table to another sql table in vb.net. Both Sql tables are in the same database. Here is my Query -

VB

SqlCmd = New SqlCommand("INERT INTO table1 SELECT * FROM table2", SqlCon)

But its giving error that incorrect syntax near INTO.
Whats wrong in it?

Posted 15-Mar-15 21:44pm

Rizwan Gazi

Updated 15-Mar-15 21:51pm

Maciej Los

v2

Add a Solution

Comments

Member 12654087 23-Nov-16 15:38pm

how to pass id of first table to second table?

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 · Accepted Answer · 2015-03-15T21:54:00

Solution 2

Proper usage of INSERT statement[^] is:

SQL

INSERT INTO Table1 (<Field_list>)
SELECT <Field_list>
FROM Table2

Never use *!
Note: Data type of source and destination fields must be the same!

Another way is to use SqlBulkCopy class[^].

Posted 15-Mar-15 21:54pm

Maciej Los

Updated 15-Mar-15 21:59pm

v2

Comments

[no name] 16-Mar-15 4:00am

5ed. I should have mentioned that. I guess I was too occupied with that pun :-)

Maciej Los 16-Mar-15 4:01am

Thank you ;)

manchanx · Accepted Answer · 2015-03-15T21:47:00

Solution 1

You have to insert an S into your insert :-)

INSERT INTO table1 SELECT * FROM table2

Posted 15-Mar-15 21:47pm

manchanx

Comments

Maciej Los 16-Mar-15 3:57am

The error message does not indicate that the reason of error is bad sql statement, but i can be wrong ;) I think it's OP's typo. Please, see my answer.

[no name] 16-Mar-15 4:03am

From my experience it does - nonetheless it's good practise to do it like you proposed.

Maciej Los 16-Mar-15 4:02am

5ed!
OP marked your answer as a solution. So, you were right! Hawk eye ;)

[no name] 16-Mar-15 4:04am

Thank you ;-)

Member 12654087 23-Nov-16 15:39pm

how to pass id of first table to second table? in vb.net