Auto Generate Numbers from different desks from sqlserver Dataabse using vb6

greenspun.com : 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

Answers

Tahir,

Use an identity column for the invoice number.

Hope this helps,

Eric

-- Anonymous, May 21, 2004


Moderation questions? read the FAQ