Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Posts
    18

    Unanswered: GUID or Identity?

    Which is better, using GUID (uniqueidentifiers) or identity(int,1,1) (autoincrement) as a PK-FK combo?

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    better for what purpose? they both have pros and cons

    GUIDs are nice if you have to pick up your data and move it somewhere else, but otherwise they certainly take up a lot of space

    rudy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •