title: How do I add string with auto increment value in SQL Server?
body: <p>How do I add a string with auto-increment value in SQL Server?</p>
  
  <pre><code>create table date (sno int 'emp_'+ identity(1,1))
  </code></pre>
  
  <p>I need following as output </p>
  
  <pre><code>emp_1
  emp_2
  </code></pre>