title: Ignore the SQL errors exceptions while inserting and continue the insertion in SQL Server
body: <p>I had data in one <code>#table</code> containig particular rows and I need to insert all those rows into an original database table. I had written the query as below</p>
  
  <pre><code>insert into tbl_user select * from #tblExcelData
  </code></pre>
  
  <p><code>#tblExcelData</code> contains multiple rows which are going to insert in <code>tbl_user</code>.</p>
  
  <p>But while insertion due to a one-row foreign key exception is fired and after that insertion is stopped.</p>
  
  <p>I want to continue this insertion for other rows. It is ok that the faulty Row which is the reason for the exception is not get inserted but other rows should continue.</p>
  
  <p>Is there any way in SQL Server to do this?</p>