Close

select into

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] Result (19614 row(s) […]

Read More