SQL Server : Inserting Rows Using INSERT...SELECT

Created 13 February 2004 00:00
To copy all the data from one table into another:
INSERT INTO Destination
   SELECT Col1, Col2, Col3
   FROM Source
   WHERE Col1 = 'example'

To copy a table and all it's data (not including primary keys, indexes, etc.):

SELECT * INTO Destination FROM Source