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