Type conversions and Nulls

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

    Tom

  • 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[/url]
    Before posting a performance problem please read[/url]

  • 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:

  • Thanks Tom!

    Really appreciate the way solution is explained.

    ~ Lokesh Vij


    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • So many back to basics in such a short question. 🙂

    --------------------------------------------------------------------------------------
    Hai Ton
    My Db4Breakfast blog.

  • 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.

  • 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..

  • Awesome, thank you Tom.

    (up until now never knew this, all the time i used simple case.... 🙁 even though BOL has mentioned this clearly i never looked it properly 😛 OR may-be I never cared much....)

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • 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
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • This was removed by the editor as SPAM

  • I knew there was a trick to this one,

    really good question thanks 🙂

    Regards
    ld

    Stoke-on-Trent
    United Kingdom

    If at first you don't succeed, go to the pub and drink away your current thought plan.

  • Thanks for the question Tom, nice reminder of the basics.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • 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!


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • Good one. Thanks for this. +1

  • nice question. and superb explanation.Thanks, Tom

    ***Manik

    Go fast as possible

    Manik
    You cannot get to the top by sitting on your bottom.

Viewing 15 posts - 1 through 15 (of 49 total)

You must be logged in to reply to this topic. Login to reply