Ravindra reddy

Ravindra reddy

  • NA
  • 12
  • 22.3k

I want to start auto incrment number start emp001,emp002...

Jul 10 2013 10:28 PM
 identity column will work only for integer values. Suppose if I want to set id value starts from 08U13000 and increase that value based on new records inserted in table like 08U1300008U1300108U13002, etc…or emp01,emp02,emp03..........
please give me the complete coding....?

Answers (4)