INTO Clause (Transact-SQL)

SELECT…INTO creates a new table in the default filegroup and inserts the resulting rows from the query into it. To view the complete SELECT syntax, see SELECT (Transact ... new_table Specifies the name of a new table to be created, based on the columns in

msdn.microsoft.com