Create Table and Copy Data from One Table to Another Table -MSSQL iSummation

Today i need to create a table and copy data from one table to another table using MSSQL.

I was googling for the same and found a single statement that can do.

Please have a look at below code.

[code:sql]

select * into test_new from test_old;

[/code]

This code will create new table named ‘test_new’ and copies all data from existing ‘test_old’ table.

Create Table and Copy Data from One Table to Another Table -MSSQL