Copy data from another table using INSERT

September 20, 2010 SQL Snippet

INSERT INTO MyDestinationTable (MyField1, MyField2, MyField3)
SELECT MyField1, MyField2, MyField3 FROM MySourceTable

If your two tables have the exact same structure you may omit the list of columns in both the INSERT and SELECT sub statements, but it doesn't hurt to be explicit.

Copy data from another table using INSERT

Related posts:

Comments