title: Avoid Duplicate Inserts - SQL Server
body: <p>I have a table with 5 columns. I added a unique index for 2 columns on this table. However whenever there were duplicates, query was stopping with an error. </p>
  
  <p>So, in MySQL I used </p>
  
  <pre><code>insert IGNORE 
  into TABLENAME1 (COLUMNS) 
  SELECT COLUMNS from TABLENAME2  
  </code></pre>
  
  <p>and I was able to overcome the duplicate error and insert the other rows.</p>
  
  <p>Can you please help me achieve the same in SQL Server? In other words, what will be a equivalent for IGNORE of mysql for duplicate row skip and inserting other rows?</p>