INTO

Inserts fields into a new table from a source table

SELECT Id,
	Name
	INTO SchemaName.TableNameCopy
FROM SchemaName.TableName
	WHERE ...