title: Insert multiple rows into a table and capture any errors during insert
body: <p>I am trying to insert multiple rows into a table and if one of the rows are violating any rule I want to capture that row alone and rest of them should be inserted. </p>
  
  <p>Is there any way of doing this in SQL server by using queries and not SSIS?</p>