Cloud & SQLSailor

SELECT INTO command helps you to do this :

SELECT  * INTO Test_Data
from HumanResources.Employee

Test_Data will be a  new permanent table and data from Employee will be transferred as it is.

You can also create Local and Global TEMP Tables too with this clause.