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.
Introduction
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,
Name varchar(15),
Age int,
salary varchar(25),
) |
Statement show data in mcnnew table
The table is given below
Statement that copying data in to a new Table(mcnrep)
select * into mcnrep
from mcnnew
|
Statement show data in mcnrep table
The table(mcnrep) is given below