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 «««12345»»»

Type conversions and Nulls Expand / Collapse
Author
Message
Posted Tuesday, February 05, 2013 6:52 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 7:08 AM
Points: 1,726, Visits: 1,253
Great question and awesome explanation.



Yeah, uh huh, you know what it is. Everything I do, I do it big

Post #1415809
Posted Tuesday, February 05, 2013 6:55 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, April 21, 2014 10:49 AM
Points: 662, Visits: 69
Good question and explanation Tom.
Thanks,
Post #1415812
Posted Tuesday, February 05, 2013 7:08 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:49 PM
Points: 12,016, Visits: 11,046
Great question Tom. My only complaint is that it was so well written there is no room for ambiguity or misinterpretation.

_______________________________________________________________

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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1415819
Posted Tuesday, February 05, 2013 7:36 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 2:23 PM
Points: 216, Visits: 182
Very nice question, and excellent explanation.
Post #1415838
Posted Tuesday, February 05, 2013 7:39 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:24 PM
Points: 1,195, Visits: 2,037
Great question, thanks Tom!
Post #1415840
Posted Tuesday, February 05, 2013 8:18 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 3:34 PM
Points: 8,295, Visits: 8,748
bitbucket-25253 (2/4/2013)
nice question .. glad to see you contributing to the QOD to allow others to learn what you can teach.

I've got a long way to catch up with your number of questions, Ron, and even further to go before my average question quality reaches any where near as high as yours.


Tom
Post #1415878
Posted Tuesday, February 05, 2013 8:23 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 3:34 PM
Points: 8,295, Visits: 8,748
john.moreno (2/4/2013)
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.

Originally I had 28 December, but then thought "oh, people will expect a trick if I use that date" so changed it.
PS There was some sort of typo or word missing trom the explanation.

Yes, there was: "there" instead of "none", a very silly typo. I started with "if there isn't one of the tests which delivers true" or something similarly verbose and rotten style with a double negative like that, and decided to change it to "if none of the tests delivers true" and screwed up the edit.


Tom
Post #1415882
Posted Tuesday, February 05, 2013 8:27 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 3:34 PM
Points: 8,295, Visits: 8,748
Dineshbabu (2/4/2013)
Nice one Tom.

Tom I need ask you one thing.

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

Raghu has answered that one at least as well as I could. I think the collation got described because there was a different question fro which the collation mattered very much, and I was cutting and pasting. Similarly, the database name came from a question that had a "USE" statement for that db. Careless cutting and pasting, but those things may have helped get people to stop and think so I don't feel guilty about it.


Tom
Post #1415889
Posted Tuesday, February 05, 2013 9:21 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, March 11, 2014 8:44 AM
Points: 212, Visits: 217
A great qotd and explanation. Had thunk it many times before getting it right...









___________________________________________________________________
If I can answer a question then anyone can answer it..trying to reverse the logic..
Post #1415939
Posted Tuesday, February 05, 2013 9:22 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, April 21, 2014 11:54 AM
Points: 1,685, Visits: 1,145
Hugo Kornelis (2/5/2013)
Very good question, and an awesome explanation. (Apart from one small type that you probably put in deliberately to prove that you're still human).
Thanks, Tom!


+1

When I started reading language and collation settings I was sure it was going to be one of those controversial questions. Really glad to see it wasn't!

Thanks a lot, Tom!
Post #1415943
« Prev Topic | Next Topic »

Add to briefcase «««12345»»»

Permissions Expand / Collapse