UNIQUE IDENTIFIER

• johan.van.den.bosch

  Default port

  Points: 1483

  More actions

  November 7, 2008 at 4:07 am

  #154898

  Hello,

  We have a discusion about UNIQUE IDENTIFIERS. When it is generated, how is it write into the database, is it as string or a numeric value.

  Thanks

• SwePeso

  SSC-Dedicated

  Points: 39757

  More actions

  November 10, 2008 at 1:54 am

  #896149

  UNIQUEIDENTIFIER is a 16-byte GUID.

  It is stored binary.

  ---

  N 56°04'39.16"
  E 12°55'05.25"

• Kishore.P

  SSCrazy Eights

  Points: 8147

  More actions

  November 10, 2008 at 2:01 am

  #896156

  UNIQUE IDENTIFIER is best for replication purpose also, for more info see SQL BOL.