Copy Data from a table into a new table in SQL Server 2008
In this article we are going to explain how to copy data from old table into a new table in SQL.
In this article I am going to explain how to copy data from old table into a new table in SQL.
Statement that create a table
|create table mcnnew
id int not null,
Statement show data in mcnnew table
The table is given below
Statement that copying data in to a new Table(mcnrep)
|select * into mcnrep
Statement show data in mcnrep table
The table(mcnrep) is given below