title: SQL Server throws error in trigger "Transaction doomed in trigger. Batch has been aborted."
body: <pre><code>insert into tuseractivitytrack (TrackIndustryId,tracktype) values(null,'news')
  </code></pre>
  
  <p>When I insert a null value to a column it gives error now what i have done i have put the code of substring in try catch block but still if a error generated it generate a error     and the rows does'nt get inserted     </p>