title: How to auto generate a ID with random numbers in sql server
body: <p>For example I had a column named 'ID'
  I want to get the output as</p>
  
  <pre><code>ID
  ---
  ABCXX708
  ABCXX976
  ABCXX654
  ABCXX081
  </code></pre>
  
  <p>In short ABCXX should be common for every row but the remaining 3 numbers should be random and integer..</p>