Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Your opinion: GUID or IDENTITY as primary key?

Status
Not open for further replies.
john76

john76

MIS
Oct 2, 2003
182
US
In the interests of continuing our fine discussions of individual preferences towards database development, what is your preference for the primary key data type? GUID or int IDENTITY?

John
 
Sort by date Sort by votes
I prefer IDENTITY, only because it allows me to read back the data later easily. I have seen many requests for data and being able to quickly get and read that ID is nice for me...
 
Upvote 0 Downvote
I like identity because it also definitively nails down row insert order. And if I ever have to do ad-hoc queries of my database it sure is easier to type
[blue]WHERE ID = 3127492418[/blue]
than
[blue]WHERE ID = '{FB6BA828-E616-11D1-8D27-00AA00B5BADA}'[/blue].
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Conditional Foreign Key Constraint
Replies
1
Views
447
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
Converting or getting rid of decimal places 1
Replies
5
Views
438
Andrzejek
Andrzejek
niall5098
  • Locked
  • Question
Create plan guide with date time parameters
Replies
3
Views
348
Chris Miller
Chris Miller
ahmedsa2018
  • Locked
  • Question
Part Id 3900 take wrong technology id as 7 and it must Be 2 because Feature Name and Value Exist?
Replies
4
Views
276
mikrom
mikrom
ahmedsa2018
  • Locked
  • Question
How to give same number if it exist on table or new number if it not exist based on part value? 1
Replies
8
Views
448
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top