Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Getting a unique key to be used across tables
Message
De
24/11/2004 14:16:25
Charlie Schreiner
Myers and Stauffer Consulting
Topeka, Kansas, États-Unis
 
 
À
24/11/2004 11:03:23
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Divers
Thread ID:
00955413
Message ID:
00964454
Vues:
13
Hi Kevin,
I now know I mean @@RowCount. In VFP, with native tables, my current GetTheNextKey function doesn't use record locking either. I'm using a cursorAdapter with ConflictCheckType = 3. If there is a conflict writing the new key to the keys table, I know that someone else has updated it since I got the last key, so I must retry. When I run two processes in a loop, both asking for the next key, I actually get better performance than when I use conventional locking.

>Thanks, Venelina (and everyone else)
>
>I got side-tracked on a bunch of different issues, and am now coming back to this one. Venelina and Charlie's responses in particular were interesting, and I'm evaluating every idea right now. Sorry for not responding sooner.
>
>Thanks!
>Kevin
Charlie
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform