title: "select * into table" Will it work for inserting data into existing table
body: <p>I am trying to insert data from one of my existing table into another existing table.</p>
  
  <p>Is it possible to insert data into any existing table using <code>select * into</code>  query.
  I think it can be done using union but in that case i need to record all data of my existing table into temporary table, then drop that table and finally than apply union to insert all records into same table</p>
  
  <p>eg.</p>
  
  <pre><code>select * into #tblExisting from tblExisting
  drop table tblExisting
  select * into tblExisting from #tblExisting union tblActualData
  </code></pre>
  
  <p>Here tblExisting is the table where I actually want to store all data
  tblActualData is the table from where data is to be appended to tblExisting.</p>
  
  <p><strong>Is it right method.
  Do we have some other alternative ?</strong></p>