How to insert data from one table to another in SQL Server

To insert data from one table to an already created table, you can use INSERT INTO SELECT command.
In this example the table named dbo.currency_copy was created earlier. If the columns in both tables are the same, it is not necessary to list the columns:

USE AdventureWorks
INSERT INTO dbo.currency_copy
SELECT * FROM Sales.Currency

Here is the same command where the columns are explicitly listed:

USE AdventureWorks
INSERT INTO dbo.currency_copy
SELECT CurrencyCode, Name, ModifiedDate FROM Sales.Currency

Read a related articles:

How to create a copy of a Table using SELECT INTO in SQL Server

How to create a copy of a Table Structure in SQL Server

If the post helped you, please share it:
Pin It

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">