Contact Us

 Admin User     Feb,08 2017

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.