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

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.


select * into test_new from test_old;


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