---
title: "Copy data from one table to another table in SQL Server 2008 R2"  
description: "In this article I am trying to explain how to copy data from one table to another and how to copy data as well as create table in SQL Server 2008 R2."  
author: "Vijay Shukla"  
published: 2013-01-08  
updated: 2019-12-10  
canonical: https://www.mindstick.com/articles/1100/copy-data-from-one-table-to-another-table-in-sql-server-2008-r2  
category: "database"  
tags: ["database"]  
reading_time: 2 minutes  

---

# Copy data from one table to another table in SQL Server 2008 R2

In this [article](https://yourviews.mindstick.com/view/81489/kashmir-now-after-an-year-of-abrogation-of-article-370) I [am trying](https://answers.mindstick.com/qa/36834/which-two-programming-languages-should-i-master-in-if-i-am-trying-to-get-into-google-or-facebook) to [explain](https://www.mindstick.com/forum/159699/what-is-a-compilation-error-in-dot-net-core-explain-with-an-example) how to copy data from [one table](https://www.mindstick.com/forum/538/copy-one-table-to-another-in-sql-server-automatically) to another and how to copy data [as well as](https://www.mindstick.com/forum/156547/difference-between-max-width-and-width-as-well-as-max-height-and-height) create [table in SQL](https://www.mindstick.com/forum/205/find-the-all-column-with-schema-for-any-table-in-sql-server) Server 2008 R2.\

We know that stored data is very important for us and [data backup](https://www.mindstick.com/forum/242/data-backup) is also very important and suppose that we need to keep backup of the data so we can use copy data from one table to another table to take the data backup In [SQL Server](https://www.mindstick.com/articles/34/create-table-in-microsoft-sql-server) 2008 R2.

Below I Have a table with [dbo].[tblEmployee] name:

```
CREATE TABLE[dbo].[tblEmployee]
(
   iEmpId int PRIMARY KEY IDENTITY,
   vEmpName varchar(100),
   vEmpContact varchar(15)
)
INSERT INTO [dbo].[tblEmployee] VALUES('Chris Roberts','+112-4356789')
INSERT INTO [dbo].[tblEmployee] VALUES('Brad Tutterow','+145-8437567')
INSERT INTO [dbo].[tblEmployee] VALUES('Paul Mendoza','+214-6444541')
INSERT INTO [dbo].[tblEmployee] VALUES('Zack Peterson','+875-55454547')
INSERT INTO [dbo].[tblEmployee] VALUES('Vijay Shukla','+91-9365894578')
```

##### Verify:

```
select * from [dbo].[tblEmployee]
```

##### Output:

![Copy data from one table to another table in SQL Server 2008 R2](https://www.mindstick.com/mindstickarticle/2e97a716-a1cd-4df3-a4e0-c71aeb3da1da/images/bcf520b6-7993-4f84-ad6c-a186d9bfe581.png)

Now I am creating a backup table with the name [dbo].[tblEmployeeBackup]

```
CREATE TABLE [dbo].[tblEmployeeBackup]
(
  iEmpID int,
  vEmpName varchar(100),
  vEmpContact varchar(15)
)
```

And now in this step below copy the data from **[dbo]**.[tblEmployee] table to **[dbo]**.[tblEmployeeBackup] table:-

```
INSERT INTO [dbo].[tblEmployeeBackup](iEmpID, vEmpName,vEmpContact )SELECT iEmpID, vEmpName,vEmpContact FROM [dbo].[tblEmployee] WHERE iEmpID = 1
```

Above query insert the data from main table to backup table below the output:

```
select * from [dbo].[tblEmployeeBackup]
```

##### Output:

![Copy data from one table to another table in SQL Server 2008 R2](https://www.mindstick.com/mindstickarticle/2e97a716-a1cd-4df3-a4e0-c71aeb3da1da/images/069dd4d2-508d-41b1-b91b-32631831b2ff.png)

##### Create a backup table and copy data simultaneously:

Now drop the backup table:

```
drop table [dbo].[tblEmployeeBackup]
```

##### Create and copy:

```
SELECT iEmpID, vEmpName,vEmpContact INTO [dbo].[tblEmployeeBackup] FROM [dbo].[tblEmployee] WHERE iEmpID = 1
```

##### Verify:

```
select * from [dbo].[tblEmployeeBackup]
```

##### Output:

![Copy data from one table to another table in SQL Server 2008 R2](https://www.mindstick.com/mindstickarticle/2e97a716-a1cd-4df3-a4e0-c71aeb3da1da/images/069dd4d2-508d-41b1-b91b-32631831b2ff.png)

\

---

Original Source: https://www.mindstick.com/articles/1100/copy-data-from-one-table-to-another-table-in-sql-server-2008-r2

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.