title: Simple INSERT Query in SQL Server
body: <p>I m looking to a way to insert into database Table T1 from T2 (append operation_</p>
  
  <p>Table 1 : dbo.t1</p>
  
  <pre><code>col1   col2
  ----   -----
  1       ABC
  2       ABCr  
  3       ABCs
  4       ABCd
  </code></pre>
  
  <p>Table 2 : dbo.t2</p>
  
  <pre><code>col1   col2
  ----   -----
  7       ABCe
  8       ABCy  
  </code></pre>
  
  <p>Now , table 1 becomes</p>
  
  <pre><code>col1   col2
  ----   -----
  1       ABC
  2       ABCr  
  3       ABCs
  4       ABCd
  7       ABCe
  8       ABCy  
  </code></pre>
  
  <p>SQL query , I m using is:</p>
  
  <pre><code>select * 
  into dbo.t1
  from dbo.t2
  </code></pre>
  
  <p>I know it would way too simple using #temp table.</p>
  
  <p>I m looking for a way so that I just append the rows from T2 to T1 and keep performance as well. The existing rows of T1 is not touch at all.</p>
  
  <p>Any help would be helpful.</p>
  
  <p>Thanks !!!</p>