Auto Generate Numbers from different desks from sqlserver Dataabse using vb6 : LUSENET : SQL Server Database Administration : One Thread

i have Developed an Accounts Software for an organization in which i generated auto Invoice Nos. using Max(VNo) Query for this. At That Time there was only one Cashier using that software. But now they want to expand the Cashier desks and retrieve the different Invoice Nos. for each desk(i.e. Distinct Invoice No. for each other). And they want to make it possible for them to enter the data at the same time with different Invoice Nos. so that no duplication is done and the record is saved simultaneously. if someone can help me solving this problem. Thanks

-- Anonymous, May 21, 2004



Use an identity column for the invoice number.

Hope this helps,


-- Anonymous, May 21, 2004

Moderation questions? read the FAQ