Inserting Rows by Using SELECT INTO - TechNet - Microsoft

The SELECT INTO statement creates a new table and populates it with the ... It can also be used to create a new table that contains d ... ... SQL Server 2008 R2.

technet.microsoft.com