- February 8, 2017
- Posted by: user
- Category: Uncategorized
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.