Vandana

Vandana

  • 1.1k
  • 589
  • 75.8k

Generate Auto increment HR_iD like COMP/MY/101

Mar 22 2017 5:24 AM
Hii,
 
I want to create auto incremented hr_id I have fetch Max(hr_id)
but how to incease numeric portion in C# code.
 
Please Tell Me.
 
The MAX(HR_ID) is COMP/MY/101
 
when I do entry in table automatically it be
 
COMP/MY/102
 
for other COMP/MY/103 and so on...

Answers (4)