How to insert all records of a table into a new table in the SQL server?

Question

Krishnapriya Rajeev · Answer

To insert all records of a table into a new table in the SQL server, we can use the INSERT INTO SELECT command.

An example is demonstrated below:

Let the table with the records be:

TABLE1

column1	column2	column3
123	Mike	Adams
345	John	Jacob
567	John	Joel

Our task is to transfer the records from TABLE1 to a new table named TABLE2. We have created TABLE2 and inserted the values into it, as demonstrated below:

Here is the table with the data inserted:

TABLE2

column1	column2	column3
345	John	Jacob
567	John	Joel

forum

How to insert all records of a table into a new table in the SQL server?

Can you answer this question?

1 Answers