SELECT INTO

This is a quick way to copy data from one table to the other. The other table will be created.

See example below, using the AdventureWorks2012 sample database from Microsoft

SELECT
[AddressID]       ,[AddressLine1]       ,[AddressLine2]       ,[City]       ,[StateProvinceID]       ,[PostalCode]       ,[SpatialLocation]       ,[rowguid]       ,[ModifiedDate]
into   MyList
FROM   [AdventureWorks2012].[Person].[Address]

6-5-2013 8-12-58 PM

Result (19614 row(s) affected)