Sql query for inserting all records from one table to another existing table

Question

I am using sql server as my database engine. I need a sql query, so that I can insert all records from one table to another existing table. Both tables are in same DB.

I need to use this query in my code.

Answer 1

 insert into destination_table ( field1, field2, field3, ... )
 select field1, field2, field3, ...
 from source_table

Answer 2

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

INSERT INTO TargetTable SELECT * FROM SourceTable