---
title: "How to insert all records of a table into a new table in the SQL server?"  
description: "How to insert all records of a table into a new table in the SQL server?"  
author: "Ashutosh Patel"  
published: 2023-03-22  
updated: 2023-03-22  
canonical: https://www.mindstick.com/forum/157523/how-to-insert-all-records-of-a-table-into-a-new-table-in-the-sql-server  
category: "mssql server"  
tags: ["mssql server", "sql server", "sql"]  
reading_time: 1 minute  

---

# How to insert all records of a table into a new table in the SQL server?

How to [insert](https://www.mindstick.com/blog/173/executing-insert-delete-or-update-query-in-sqlserver-using-ado-dot-net) all [records](https://www.mindstick.com/forum/34640/how-to-create-a-stored-procedure-for-display-all-records) of a [table](https://www.mindstick.com/articles/43918/how-to-design-table-using-bootstrap) into a new table in the [SQL server](https://www.mindstick.com/articles/12999/what-is-table-valued-function-in-sql-server)?

## Replies

### Reply by Krishnapriya Rajeev

To insert all records of a table into a new table in the [SQL](https://www.mindstick.com/articles/13115/types-of-keys-in-sql-or-oracle-database) [server](https://www.mindstick.com/articles/43769/what-is-serverless-architecture-is-it-worth-switching-over), we can use the ***INSERT INTO SELECT*** command.

An example is demonstrated below:

Let the table with the records be:

## TABLE1

| **column1** | **column2** | **column3** |
| --- | --- | --- |
| 123 | Mike | Adams |
| 345 | John | Jacob |
| 567 | John | Joel |

Our task is to transfer the records from TABLE1 to a new table named TABLE2. We have created TABLE2 and inserted the values into it, as demonstrated below:

![How to insert all records of a table into a new table in the SQL server?](https://www.mindstick.com/mindstickforums/33124535-72ae-4901-a817-7eba93892b62/images/4b889ab3-4b3e-4d44-b50d-7b70f7421749.png)

Here is the table with the data inserted:

## TABLE2

| **column1** | **column2** | **column3** |
| --- | --- | --- |
| 345 | John | Jacob |
| 567 | John | Joel |


---

Original Source: https://www.mindstick.com/forum/157523/how-to-insert-all-records-of-a-table-into-a-new-table-in-the-sql-server

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