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.