title: How to generate a 8 digit auto increment number in SQL Server?
body: <p>I want to generate a number like: <code>ABC00000001</code>, <code>ABC00000002</code>.</p>
  <p>The number will be auto incremented and the prefix will be a string.</p>
  <p>How to generate this in SQL Server?</p>