The Into clause creates a new table from the Select…

Use AdventureWorks2016CTP3

Select

FirstName

,MiddleName

,LastName

Into [Person].[Person_Names]

From

[Person].[Person]

Select

*

From

[Person].[Person_Names]

FirstName        MiddleName        LastName

Syed        E        Abbas

Catherine        R.        Abel

Kim        NULL        Abercrombie

Kim        NULL        Abercrombie

Kim        B        Abercrombie