---
title: "How data can be copied from one table to another table?"  
description: "How data can be copied from one table to another table?"  
author: "Ashutosh Kumar Verma"  
published: 2021-11-10  
updated: 2021-11-10  
canonical: https://www.mindstick.com/forum/156825/how-data-can-be-copied-from-one-table-to-another-table  
category: "mssql server"  
tags: ["sql server", "sql"]  
reading_time: 2 minutes  

---

# How data can be copied from one table to another table?

How [data](https://www.mindstick.com/articles/13050/salesforce-aiming-to-dominate-predictive-analytics-with-data-science) can be copied from [one table](https://www.mindstick.com/forum/538/copy-one-table-to-another-in-sql-server-automatically) to another table?

## Replies

### Reply by Steilla Mitchel

**SQL command to copy data from one [table](https://www.mindstick.com/articles/43918/how-to-design-table-using-bootstrap) into another table:**

There are two different SQL command to copy all records or selected records from existing table into another table, which are like as-

## 1- INSERT INTO SELECT:

This SQL statement is used when need to copy all records of a table into another created table. In this statement a new table is need to create with same column and datatype as like existing table.

Syntax-![How data can be copied from one table to another table?](https://www.mindstick.com/mindstickforums/0edf5a0e-b2f2-45f9-bc0b-8976069d55ed/images/f62863ea-d756-4910-8121-5568847ba8c6.png)

![How data can be copied from one table to another table?](https://www.mindstick.com/mindstickforums/0edf5a0e-b2f2-45f9-bc0b-8976069d55ed/images/0a59722b-ec21-480e-a630-3f61d748cfc8.png)

## 2- SELECT INTO:

This SQL statement is used when need to copy all records of existing table into a new table that are not created means here don’t need to create a new table because this SQL statement is copies all records as well as definitions of existing table and paste into new table name with column name and its datatype.

Syntax-![How data can be copied from one table to another table?](https://www.mindstick.com/mindstickforums/0edf5a0e-b2f2-45f9-bc0b-8976069d55ed/images/0d22614a-49a2-4345-95fa-c242b04bb030.png)

![How data can be copied from one table to another table?](https://www.mindstick.com/mindstickforums/0edf5a0e-b2f2-45f9-bc0b-8976069d55ed/images/5f746dcb-1575-4b7c-ba55-7c3ef939c9f9.png)


---

Original Source: https://www.mindstick.com/forum/156825/how-data-can-be-copied-from-one-table-to-another-table

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