SQL SERVER 2014 - SELECT INTO, ORDER BY - automatic clustered index? When I create a table using SELECT INTO A, and it has ORDER BY x, does SQL server automatically make x the primary key of A (thus auto create a clustered index)?
No, the ORDER BY applies to the SELECT query and not to the table created by SELECT INTO.
Using ORDER BY is unnecessary in this statement, because it doesn't even guarantee the rows are inserted into the new table in that order.
See INTO Clause (Transact-SQL)