Hi Cetin,
>Why are you inventing newid when SQL server has one NewID() or IDENTITY or Timestamp.
You raise a good point. A VFP/SQL application I took-over about 3 years ago has all its tables with integer pk fields, but the pk values are allocated via. a single 'control' table (called UniqueID), with one record for each table. Unfortunately none of the PK fields are auto-incremented identity fields.
I have only just discovered that SQL also has a NewId function (otherwise I might have called my VFP function something else!), but this produces a very complicated unique-identifer - my application only requires integer values.
Regards,
Alan
Précédent
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