title: ID auto increment and update in SQL Server database
body: <p>Inside my SQL Server database I got this as my <code>ID</code> for example <code>SSK0000001</code>.</p>
  
  <p>I want it to auto-increment in my system and also the last number of <code>ID</code> e.g."1" (after another new record it will become <code>SSK0000002</code>) is update in my SQL Server database.</p>
  
  <p>I know it can be done with set auto-increment inside database but now my <code>ID</code> is <code>nchar</code>. </p>
  
  <p>Anyone could help will be appreciate. </p>