That is the point of an identity. By using an identity column you are 
asking the database to ensure that this problem will not occur. An 
identity provides a unique identifier for that row.

regards
David Cameron
nOw.b2b
dcameron@i...

> -----Original Message-----
> From: Bab Tools [mailto:babtools@h...]
> Sent: Thursday, 14 November 2002 12:26 PM
> To: sql language
> Subject: [sql_language] RE: Identity
>
>
> Thanks for that. Lets say on a very busy site where people
> are opening
> accounts continously would this prevent two users being given
> the same ID
> if say they access the DBMS simultaneously?
>
> > That sets that field to auto increment starting at one and
> incrementing
> by one on each insert.
>
> Mike
>
>