General information
Category:
Coding, syntax and commands
Title:
Get next number from SQL Server
In our order entry application, when an order is created, the next available order number is taken from a field in a table. Then, the field is incremented by 1 for the next time this routine is called.
We want to use a SQL Server table within our .Net application to manage the next number field. However, how can we lock the table in our routine, while it's getting and incrementing the field, so that no other user can access the table. Then unlock the table when done.
We want to avoid two or more users getting the same next number order number from the table's field.
How can this be done?
Thanks,
Jerry
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only