COPY DATA FROM ONE TABLE TO ANOTHER IN SQL SERVER 2005

CREATE TABLE EMPLOYEE
(
id INT IDENTITY(1,1) PRIMARY KEY NOT NULL,
EMPNAME VARCHAR(100),
SALARY DECIMAL
)

INSERT INTO EMPLOYEE
SELECT ‘Pawan’ , 180000
UNION ALL
SELECT ‘Gaurav’ , 80000
UNION ALL
SELECT ‘Saurabh’ , 80000
UNION ALL
SELECT ‘Pawan’ , 830000
UNION ALL
SELECT ‘Neelam’ , 80000

SELECT * FROM EMPLOYEE

CREATE TABLE COPYEMPLOYEE
(
id INT IDENTITY(1,1) PRIMARY KEY NOT NULL,
EMPNAME VARCHAR(100),
SALARY DECIMAL
)

—USE the following query to copy data from table to another

INSERT INTO COPYEMPLOYEE
SELECT EMPNAME ,  SALARY FROM EMPLOYEE

–CHECK Data in the new data

SELECT * FROM COPYEMPLOYEE

Share Knowledge.We all are here to learn.

Pawan Kumar

Pawankkmr@hotmail.com