|
swissivan
Starting Member
29 Posts |
 Posted - 02/05/2013 : 23:36:22
|
A table is used for storing current number of Sales Order
CurrentNumber
| name | prefix | current_number |
| SalesOrder | SO | 10 |
I got multiple users to access this row to get the latest number
INSERT INTO SalesOrder (id,field2,...) SELECT (prefix + RIGHT('000' + CAST(current_number AS VARCHAR(4)), 4)), value2,... FROM CurrentNumber
Then update the current_number to 11
How to add locking on this row to prevent two users create sales order with same number? Thanks for any comments. |
|
SQL Locking
