Type conversions and Nulls

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Tom Thomson » Type conversions and Nulls

49 posts, Page 1 of 5

1 2 3 4 5 »»»

Type conversions and Nulls

Rate Topic

Display Mode

Topic Options

Author

Message

L' Eomot Inversé

Posted Monday, February 04, 2013 8:25 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 11:14 AM
Points: 7,087, Visits: 7,141

Comments posted to this topic are about the item Type conversions and Nulls

Tom
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)

Post #1415558

bitbucket-25253

Posted Monday, February 04, 2013 8:27 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:04 PM
Points: 5,101, Visits: 20,200

L' Eomot Inversé

nice question .. glad to see you contributing to the QOD to allow others to learn what you can teach.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read
Before posting a performance problem please read

Post #1415559

demonfox

Posted Monday, February 04, 2013 9:31 PM

Ten Centuries

Group: General Forum Members
Last Login: Saturday, May 18, 2013 6:46 PM
Points: 1,074, Visits: 1,076

bitbucket-25253 (2/4/2013)

L' Eomot Inversé

nice question .. glad to see you contributing to the QOD to allow others to learn what you can teach.

+1

thanks for the question Tom ..

~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one Ermm

Post #1415563

Lokesh Vij

Posted Monday, February 04, 2013 10:43 PM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 11:26 AM
Points: 1,173, Visits: 1,249

Thanks Tom!
Really appreciate the way solution is explained.

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter

Post #1415574

db4breakfast

Posted Monday, February 04, 2013 11:22 PM

Old Hand

Group: General Forum Members
Last Login: Sunday, May 05, 2013 11:42 AM
Points: 374, Visits: 326

So many back to basics in such a short question. Smile

--------------------------------------------------------------------------------------
Hai Ton
My DB4BREAKFAST blog: http://db4breakfast.blogspot.com

Post #1415580

john.moreno

Posted Monday, February 04, 2013 11:43 PM

Old Hand

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 10:31 PM
Points: 339, Visits: 950

I got it right, but I wish the date wasn't April Fools day -- it adds a bit of "meta" distraction to the question.

Is it ha, ha fooled you if you pick it, or ha, ha should have picked this? Either way, an unwelcome distraction from an otherwise nice question.

PS There was some sort of typo or word missing trom the explanation.

Post #1415584

Dineshbabu

Posted Monday, February 04, 2013 11:45 PM

Right there with Babe

Group: General Forum Members
Last Login: Thursday, May 09, 2013 8:50 AM
Points: 746, Visits: 435

Nice one Tom.

Tom I need ask you one thing.

Is there any collation setting to affect the result of today's question ?

--
Dineshbabu
Desire to learn new things..

Post #1415585

Raghavendra Mudugal

Posted Tuesday, February 05, 2013 12:43 AM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 10:40 AM
Points: 445, Visits: 1,196

Awesome, thank you Tom.

(up until now never knew this, all the time i used simple case.... Sad

even though BOL has mentioned this clearly i never looked it properly Tongue

OR may-be I never cared much....)

ww; Raghu
--
There are only 10 types of people in the world, those who understand binary, and those who don't.

Note: (as of now) only.. 1 and 4 applies (i am on my way...)

Post #1415616

Raghavendra Mudugal

Posted Tuesday, February 05, 2013 1:02 AM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 10:40 AM
Points: 445, Visits: 1,196

Dineshbabu (2/4/2013)

...Is there any collation setting to affect the result of today's question ?

(well, to my ~~knowledge~~ understanding, I don't think precedence change according to the collation, and I think the mention of the collation - creates a thought that - even though the output format is given as "date" the format is not as expected, so possible we start to wonder there must be some kind of overriding or in the settings... but it is just a precedence and the case statement dealing with the boolean expression)

ww; Raghu
--
There are only 10 types of people in the world, those who understand binary, and those who don't.

Note: (as of now) only.. 1 and 4 applies (i am on my way...)

Post #1415622

Stewart "Arturius" Campbell

Posted Tuesday, February 05, 2013 1:31 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 3:48 AM
Points: 3,125, Visits: 4,311

Good question, thanks Tom

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Post #1415639

« Prev Topic | Next Topic »

49 posts, Page 1 of 5

1 2 3 4 5 »»»

Permissions