title: How to skip insertion of a duplicate record and continue in Sybase T-SQL?
body: <p>I am inserting several million rows using the following simple <code>insert</code> clause:</p>
  
  <pre><code>insert into DEST_TABLE
  select *
  from SRC_TABLE
  </code></pre>
  
  <p>However, there may be duplicates while inserting, which will throw an error and the entire operation will end.</p>
  
  <p>Is there a way to perform the insertion operation from start to finish and not break from duplicate insertion errors aka. ignore duplicate insertion errors and do not insert them?</p>