I want to have an alternative way to increment my student no.
the current way I'm doing to is in my database, mssql. there's a property called Identity Seed(201200001 - my studentid format) and Identity Increment (1 - no. of increments).
The 2012-is the school year, while the 00001- is the no of the student.
what can i do for next school year and upcoming years, the student no would have to be 201300001 but for that to happen the student no must reach 201299999 but that no of students enrolling for a school year is impossible.
can i do this by code instead?