Admin User Feb,08 2017
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.