Post reply

Type conversions and Nulls

  • February 4, 2013 at 8:25 pm

    #394101

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

    Tom

  • February 4, 2013 at 8:27 pm

    #1584166

    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]

  • February 4, 2013 at 9:31 pm

    #1584169

    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:

  • February 4, 2013 at 10:43 pm

    #1584176

    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

  • February 4, 2013 at 11:22 pm

    #1584180

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

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

  • February 4, 2013 at 11:43 pm

    #1584182

    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.

  • February 4, 2013 at 11:45 pm

    #1584183

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

  • February 5, 2013 at 12:43 am

    #1584194

    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.

  • February 5, 2013 at 1:02 am

    #1584198

    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.

  • February 5, 2013 at 1:31 am

    This was removed by the editor as SPAM

  • February 5, 2013 at 2:12 am

    #1584226

    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.

  • February 5, 2013 at 2:35 am

    #1584232

    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

  • February 5, 2013 at 2:42 am

    #1584238

    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/

  • February 5, 2013 at 3:07 am

    #1584248

    Good one. Thanks for this. +1

  • February 5, 2013 at 3:59 am

    #1584266

    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