Создайте отдельно таблицу серийных номеров, возьмите оттуда серийный номер и автоинкрементируйте. ⇐ C#

[Anonymous]

I want to create a table that will store sequence for different fields against each company in a desktop application through SQL and C#. When the data is entered, the fields should pick up sequence from the sequence table and auto increment the same with each entry. The user will get the discretion to choose the starting value of the series. Every time the user changes the starting value of the series the same is picked up in the data entry table and then auto incremented with each entry.

I am trying to achieve this with the help of a stored procedure but unable to to so. I want to enter the first entry of sequence as it is from the sequence table and then increment it. When the user changed the starting series the table should pick and start with that number and increment accordingly.


Источник: https://stackoverflow.com/questions/781 ... ere-and-au