how to create auto increment column with characters and number like alphanumeric in sql server?
<p>i have a table with primary key column which is auto-increment id of numerals starting from 1000..</p>

<p>now i have been asked to make a unique key for each records which starts with C20161, C20162, C20163 and so on the series goes on.....</p>

<p>so it is actually an alphanumeric key that auto-increments....</p>

<p>i would like to know how to implement the same in sql and also can i update the same to existing records?</p>

<p>is 'sequence' what i am looking for or something else?</p>