CTAS with clustered index on SQL Server
You have to add the index in a separate step.

From MSDN:


  Indexes, constraints, and triggers defined in the source table are not
  transferred to the new table, nor can they be specified in the
  SELECT...INTO statement. If these objects are required, you must
  create them after executing the SELECT...INTO statement.