Geek Answers Handbook

Sql query to insert all records from one table into another existing table

I use sql server as a database engine. I need a sql query, so I can insert all the records from one table into another existing table. Both tables are in the same DB.

I need to use this request in my code.

+4
source share
2 answers
insert into destination_table ( field1, field2, field3, ... ) select field1, field2, field3, ... from source_table
+10
source

Assuming all fields are the same (are in the same order of the same type)

 INSERT INTO TargetTable SELECT * FROM SourceTable
+1
source

More articles:


All Articles