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.
  • 2265

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

 Clipboard04.jpg

The table is given below

Clipboard07.jpg

Statement that copying data in to a new Table(mcnrep)

select * into mcnrep
from mcnnew
 

Statement show data in mcnrep table

Clipboard12.jpg

The table(mcnrep) is given below

Clipboard07.jpg

© 2020 DotNetHeaven. All rights reserved.