title: SQL Server  'select * into' versus 'insert into ..select *
body: <p>Say <code>table1</code> and <code>table2</code> already exist, is there any difference between these queries</p>
  
  <p>query1 :-</p>
  
  <pre><code>select * into table1 from table2 where 1=1
  </code></pre>
  
  <p>query2: -</p>
  
  <pre><code>insert into table1 select * from table2
  </code></pre>