Generating alphanumeric autogenerated ID

Question

I want to generate alphanumeric student Id based on department for BTECH students using SQL Server like 10F21A0404.In this,the ID will be incremented up to 499 and after that it should be incremented as 4A0-4A9 and 4B0-4B9 and etc..For other departments also it has increment as 10F21A0500 like wise it has to increment 5A0-5A9 and etc

Dipankar Biswas · Answer

Hi.. Check this links.. Some examples here.. http://stackoverflow.com/questions/2452578/auto-generate-alphanumeric-unique-id-with-c-sharp http://beta.c-sharpcorner.com/Forums/Thread/163919/hi-how-to-auto-increment-for-text-and-char-in-sql-table.aspx http://dotnetadda.blogspot.in/2010/05/auto-generate-alphanumeric-ids-in-sql.html