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
|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
The table(mcnrep) is given below