title: Create table as select causes error in SQL Server
body: <p>It's strange or I am new? Here is a simple create table as select causing an error in SQL Server 2008.</p>
  
  <pre><code>CREATE TABLE [SalesOrderHeader2]
  AS
      (SELECT *
       FROM [AW].[sales].SalesOrderHeader)
  </code></pre>
  
  <p>Error:</p>
  
  <blockquote>
    <p>Msg 156, Level 15, State 1, Line 2<br>
    Incorrect syntax near the keyword 'as'.</p>
  </blockquote>
  
  <p>No error in oracle:</p>
  
  <pre><code>create table abc AS 
  select * from abc2
  </code></pre>