I have an ASP.Net page that has SQL for its back end. I need to be able to present the user with an auto-generated value say 200 and then auto-increment this value by 1 but then after it gets to a certain value say 300, I need to loop the value back to 200. What is the best way to go about this? I was thinking of using a stored procedure that looks at the current value and then depending on what it is either updates or loops around. Is that the best way to go about this? If so, then how do you link in a stored procedure with an ASP.Net MVC4 web page?
Loop value in SQL column
- Thread starter rcpkrc
- Start date