January 20, 2015 at 5:25 am
I've seen numerous examples of both conventions, so there's no right or wrong here.
But as the ID/Id bit is abbreviating only a single word, the rational side of me chooses Id. My colleagues are uniformly against me! What do others think?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
January 20, 2015 at 5:29 am
I use ID, everyone else in my company uses Id.
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
January 20, 2015 at 5:31 am
ID (or Id or I.D.) is not necessarily an abbreviation of the word "identity". It can also be an acronym for "identity document", such as drivers ID or national ID (passport). To be honest, it should be I.D. in that case, but anyway 🙂
According to Wikipedia, it can also be short for "identifier". In the article, they shorten it with ID for some reason (but hey, how trustworthy is Wikipedia?).
Personally I prefer ID, but I cannot give any objective claim on why it is better than Id.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 20, 2015 at 5:31 am
GilaMonster (1/20/2015)
I use ID, everyone else in my company uses Id.
So, you switch places with Phil and everything is settled then. 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 20, 2015 at 5:33 am
Both are good to me, plus:
product_id
... as per column name convention in system tables ...
January 20, 2015 at 5:35 am
According to Merriam-Webster: it should be ID.
Id - or in a sentence id - refers to part of the psyche defined by Freud.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 20, 2015 at 5:36 am
Eugene Elutin (1/20/2015)
Both are good to me, plus:product_id
... as per column name convention in system tables ...
Right, as if system tables are consistent 😀
(and why should we trust Microsoft on this delicate matter? :-))
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 20, 2015 at 5:38 am
Phil Parkin (1/20/2015)
But as the ID/Id bit is abbreviating only a single word, the rational side of me chooses Id.
Also, following your logic, it should be Tv instead of TV. 😛
(I am doing way too much research over here)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 20, 2015 at 5:42 am
According to Merriam-Webster: it should be ID.
Id - or in a sentence id - refers to part of the psyche defined by Freud.
For a bit of balance, have a look at Microsoft's recommendations here.
--Edit: wrong post quoted – fixed. This has happened to me a few times recently. Either there's a bug somewhere or I should bring forward my retirement plans.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
January 20, 2015 at 5:47 am
I used ID, there was no reason behind it 🙂
January 20, 2015 at 5:53 am
Phil Parkin (1/20/2015)
According to Merriam-Webster: it should be ID.
Id - or in a sentence id - refers to part of the psyche defined by Freud.
For a bit of balance, have a look at Microsoft's recommendations here.
--Edit: wrong post quoted – fixed. This has happened to me a few times recently. Either there's a bug somewhere or I should bring forward my retirement plans.
It's very known bug, which we have nicknamed "the quote bug".
It happens when you quote someone while someone else is also posting a reply.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 20, 2015 at 6:20 am
Koen Verbeeck (1/20/2015)
Phil Parkin (1/20/2015)
According to Merriam-Webster: it should be ID.
Id - or in a sentence id - refers to part of the psyche defined by Freud.
For a bit of balance, have a look at Microsoft's recommendations here.
--Edit: wrong post quoted – fixed. This has happened to me a few times recently. Either there's a bug somewhere or I should bring forward my retirement plans.
It's very known bug, which we have nicknamed "the quote bug".
It happens when you quote someone while someone else is also posting a reply.
Thanks for that. Thought I was going bananas 🙂
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
January 20, 2015 at 8:35 am
I tend to use Id rather than ID. Mainly due to being trained to use Pascal case naming conventions, even when I'm typing I occasionally throw in a capital letter at the start of a word mid sentence.
_________________________________________________________________________
SSC Guide to Posting and Best Practices
January 20, 2015 at 9:21 am
Koen Verbeeck (1/20/2015)
Personally I prefer ID, but I cannot give any objective claim on why it is better than Id.
What a minute....we agree on this one. 😉
I use ID but like many others have no particular reason one way or the other as to why. I don't have any strong opinion on this. If I type the column name it would be ID but I have no issues if the name is Id. For some reason I always think the mixed case looks funny though.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
January 20, 2015 at 9:22 am
Jason-299789 (1/20/2015)
I tend to use Id rather than ID. Mainly due to being trained to use Pascal case naming conventions, even when I'm typing I occasionally throw in a capital letter at the start of a word mid sentence.
The lady who ran our kids daycare a few years ago used to send newsletters to the parents each month. She capitalized the first letter of every single word in every email. It must have taken her hours to type up these emails, and they were damn difficult to read too.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 15 posts - 1 through 15 (of 103 total)
You must be logged in to reply to this topic. Login to reply