title: Auto Increment a non-identity Column in sql-server
body: <p>We have Non-<code>Identity</code> <code>Column</code> in our Database Which have a specific value . We have a requirement as below,</p>
  
  <p>Whenever a record <code>insert</code> into that column, value should be incremented by one.</p>
  
  <p>how to handle this in <code>sql server</code> ? </p>
  
  <p>Thanks for the help.</p>