Vandana

Vandana

  • 1.2k
  • 590
  • 76.2k

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)