Mustaq Khan

Mustaq Khan

  • NA
  • 34
  • 39.1k

how to auto increment a column in a specific format

Mar 6 2013 5:53 AM
I have a column name JobCode , i want it to increment automatic in the formate A-1, A-2....A-200 then it should start from B-1,B-2...B-200 and so on upto Z-1...Z-200....!! i want to code to save the column value into sql server database.

Answers (5)