Handle Bulk insertion in sql
<p>I am using table type for bulk insertion or updating, but I am unable to deal with the case a single error in 100 records. In that case for one entry my 99 entries will fail what to do in that case?</p>