Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Returning newid(()
Message
De
30/12/2014 23:29:39
 
 
À
30/12/2014 01:04:46
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Versions des environnements
SQL Server:
SQL Server 2012
Application:
Desktop
Divers
Thread ID:
01612793
Message ID:
01612887
Vues:
49
>>
>>We always use GUID's (uniqueidentifier) because we replicate our DB's across offices. Does the Sequence Object work with SQL replication?
>>
>
>Good question, to the best of my knowledge, no, not directly. (Only thing I can think of, you'd need to generate the value on the publisher side and then use on the subscriber)

Hi!

How do you handle Primary/Foreign keys (Type - GUID/Integer/Seqence) in replicated DB's?

Thanks

Sarosh
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform