rowguidcol

• Simon_L

  SSCarpal Tunnel

  Points: 4669

  More actions

  October 6, 2008 at 9:50 am

  #71102

  I just dont get it .. whats the difference between

  _{create table guidPrimaryKey}

  (

  guidkey uniqueidentifier not null rowguidcol default newid(),

  value varchar(10)

  )

  and

  _{create table guidPrimaryKey}

  (

  guidkey uniqueidentifier not null default newid(),

  value varchar(10)

  )

  does the data therein behave any differently etc... Ive looked up rowguidcol in BOL but I still can see what the difference is

  any words of wisdom etc.. ?

  thanks si

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  October 6, 2008 at 10:02 am

  #881193

  Certain features (merge replication, filestream) require the presence of a rowguidcol in the table. Other than that, nothing that I'm aware of

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Simon_L

  SSCarpal Tunnel

  Points: 4669

  More actions

  October 7, 2008 at 8:20 am

  #881699

  GilaMonster (10/6/2008)

  ---

  Certain features (merge replication, filestream) require the presence of a rowguidcol in the table. Other than that, nothing that I'm aware of

  so unless your using any of those there is no need to speciify rowguildcol... although I guess it doesn't hurt ?

  cheers Si