Microsoft SQL Server Copy data from one table to another


Example

This code selects data out of a table and displays it in the query tool (usually SSMS)

SELECT Column1, Column2, Column3 FROM MySourceTable;

This code inserts that data into a table:

INSERT INTO MyTargetTable (Column1, Column2, Column3)
SELECT Column1, Column2, Column3 FROM MySourceTable;