title: SQL Server: Auto increment char pk
body: <p>Is it possible to have a char primary key on a table? For example 'WC001' then will it automatically increment by 1, so  the next record for the pk will be 'WC002' and so on.</p>
  
  <p>Can anyone provide me example? </p>
  
  <p>Thanks</p>