Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
RowGuid Column Property
Message
De
18/12/2008 10:27:13
Timothy Bryan
Sharpline Consultants
Conroe, Texas, États-Unis
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Versions des environnements
SQL Server:
SQL Server 2008
Divers
Thread ID:
01368502
Message ID:
01368512
Vues:
19
Thanks Sergey,

Does the rowguid now get created by SQL Server on an insert as opposed to me creating it when I create records? I would assume so since the default value now says newid()
Tim

>It doesn't do anything besides indicating that the uniqueidentifier values in the column uniquely identify rows in the table. The uniqueness must be enforced through other mechanisms, such as the PRIMARY KEY or UNIQUE KEY constraints for the column.
>It's primarily used by SQL Server replication. In SQL 2008 it's also required by the new FILESTREAM feature.
>
>>If I set the Row Guid Column property for my PK to True as it is a UID, what does this actually do? It looks like the property for Default Value on the column also got set to newid() so that must have been related and the point of it.
>>Thanks
>>Tim
>>As you can tell, I am not so savy about SQL Server
Timothy Bryan
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform