SQL Server : Inserting Rows Using INSERT...SELECT

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