Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

data type precedence! Expand / Collapse
Author
Message
Posted Monday, August 24, 2009 12:27 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, July 23, 2013 6:34 AM
Points: 654, Visits: 265
Comments posted to this topic are about the item data type precedence!
Post #775799
Posted Monday, August 24, 2009 8:40 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Saturday, April 12, 2014 4:20 AM
Points: 1,637, Visits: 422
"In SQL Server 2005, which of these data types have the highest and lowest precedence respectively?"

Yet another example of an abysmally worded question.
This question MUST have two answers, but we could tick only one.
The word "respectively" is not only superfluous but is also a distraction.

Can we PLEASE have more thorough editing of questions.

Thankyou.

Kenneth Spencer

Post #776049
Posted Monday, August 24, 2009 10:45 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 12:05 PM
Points: 3,569, Visits: 72,411
I have to agree...

respective to the first answer, the second has a lower order of precedence for both answer 1, and 2... because user defined is the top... and char/binary are both lower in precedence...


The other three are in reverse order of precedence so they're wrong.

I got it right by guessing, but both of the first two answers are correct with respect to themselves :P




--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Post #776162
Posted Monday, August 24, 2009 6:07 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 9:16 AM
Points: 20,465, Visits: 14,095
Keep in mind the question asked for highest and lowest respectively. If construed differently than the highest possible and then the lowest possible datatypes; we would still have to look at the largest difference in precedence that could be surmised by the precedence order.


http://msdn.microsoft.com/en-us/library/ms190309(SQL.90).aspx

Reading this question and then looking at the answers, we can see that each answer had two datatypes listed - thus respectively in those answers the first would be highest and the second would be lowest.


Pretty straight forward question and answer.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #776387
Posted Tuesday, November 03, 2009 1:28 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, November 05, 2013 6:08 AM
Points: 1,076, Visits: 591
[quote]CirquedeSQLeil (8/24/2009)
Keep in mind the question asked for highest and lowest respectively. If construed differently than the highest possible and then the lowest possible datatypes; quote]


What you don't know won't hurt you but what you know will make you plan to know better
Post #812784
Posted Friday, November 20, 2009 10:43 PM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, January 11, 2013 12:41 PM
Points: 621, Visits: 297
hey, this was tricky one!



Bhavesh Patel

http://bhaveshgpatel.wordpress.com/
Post #822836
Posted Thursday, March 17, 2011 6:51 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, September 25, 2013 5:10 PM
Points: 589, Visits: 2,436
I knew about that user-defined data types was the highest and I would have bet a lot that char was lower than binary...

Well, that just proove that there are some days that you might be wrong, even if you are certain à 200%!!

Thanks for the question. I learned again
Post #1080129
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse