Information générale
Titre:
Best way to generate PK on SQL table
I understand there are potential problems using Identity fields in SQL to generate a PK.
1. Trying to return value with @@identity may give value for insert on another table
2. Problems with replication
What is the best way to get around these problems? Does SQL 2000 have something to help get around #1? We plan to use replication in the future, should we use GUIDs from the beginning and forget identity fields?
Thanks.
Doug
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement