How to stop duplicate entry

#21

Quote:

I have made an project in asp with sql server. All database are without
any primary key.

This is basic stuff. Why no PK????

Bob Lehmann

<vinodkus (AT) gmail (DOT) com> wrote

Quote:

dear sir/madam
I have made an project in asp with sql server. All database are
without any primary key.
In one times many people are doing entry. So there is one field for
serial number generation and all value of this field should be unique.
But due to huge amount of entry some times clients entry
simultaneously and duplicate value enters in the field. Please tell me
how to stop it. I just want If record of one person is inserting then
other person record should be in wait so that duplicate entry should
not be entered

Thanks in Advance

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to stop duplicate entry

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

Re: How to stop duplicate entry - 02-15-2008 , 12:39 AM