rowguid

  • Thread starter Thread starter Victor
  • Start date Start date
V

Victor

hi guys
just want know, if is that rowguid field must be unique in the whole
database? can i get the rowguid from one table then insert into another
table?
 
If the guids are create via CoCreateGuid or similar algorithm, shouldn't
they be *globally* unique?
 
the guid is generated by the newid() function in the sqlce. and will be used
in the repulication as the rowguid column. in that case, can i still use
this guid as a primary key for another table?

cheers
 
acutally to resolve this problem, i create another column as rowguid, just
feel strange why this happen... want to know whether the rowguid for
replication is unique in the whole database

cheers
 
Victor said:
acutally to resolve this problem, i create another column as rowguid, just
feel strange why this happen... want to know whether the rowguid for
replication is unique in the whole database
Click to expand...
I don't see why it shouldn't, but that's my opinion.
 
I believe you confused it with IDENTITY column. But a ROWGUIDCOL from
the definitition is Globally Unique IDentifier and should be unique for
all tables in all databases within the same device.

Best regards,
Sergey Bogdanov
http://www.sergeybogdanov.com
 
Back
Top