title: SQL Server append table to an existing table
body: <p>I need to append rows from one table to an existing table. I am thinking something like following but this gives an error</p>
  
  <pre><code>select * 
  into table1
  from (select * 
        from table1
        union
        select *  
        from table2) as tmp
  </code></pre>
  
  <p>Is there a way to use <code>ALTER TABLE</code> or <code>UPDATE</code> with <code>UNION</code>?</p>