title: SQL Server Insert Without INTO
body: <p>This may be a really basic SQL question, but I have seen a SQL <strong>INSERT</strong> statement without the clause <strong>INTO</strong> and I was wondering if that is some special case in SQL Server 2000 or 2008.</p>
  
  <p>The INSERT statement look something like</p>
  
  <pre><code>INSERT &lt;table_name&gt;
  (
    column names
  )
  select *
  from &lt;another table&gt;
  where &lt;condition&gt;
  </code></pre>
  
  <p>Sorry, if this is super basic, but I just wanted to make sure.
  Thanks!</p>