ISNULL

  • DonlSimpson

    SSCertifiable

    Points: 6774

    Comments posted to this topic are about the item ISNULL

    Don Simpson



    I'm not sure about Heisenberg.

  • Hany Helmy

    SSChampion

    Points: 13435

    Eazy mozo 🙂

  • Vimal Lohani

    SSCommitted

    Points: 1650

    Good one..

    Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature

  • Koen Verbeeck

    SSC Guru

    Points: 258955

    Nice question thanks.

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

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    Thank you for the post, good one. (guessed the answer right also the explanation behind it)

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

  • TomThomson

    SSC Guru

    Points: 104772

    Nice simple one for the start of the week.

    Tom

  • This was removed by the editor as SPAM

  • SqlMel

    SSCrazy

    Points: 2891

    Good question.

    I anticipate many people will go for the NULL answer.

    ---------------
    Mel. 😎

  • Ed Wagner

    SSC Guru

    Points: 286960

    SqlMel (9/22/2014)


    Good question.

    I anticipate many people will go for the NULL answer.

    Yes they will. The concept is important, though. The presence of the row makes all the difference in the world. One might even argue the presence of rows is the start of learning to count. 😉

  • cgumprich

    SSC Eights!

    Points: 823

    Good question, thanks. I got the right answer for the wrong reason -- the explanation helped!

  • dfortier

    SSC-Addicted

    Points: 411

    Got me! 🙁

  • JustMarie

    SSCertifiable

    Points: 7771

    Made my guess, ran the code, got back NULL. Not an empty record set - NULL.

  • stephen.long.1

    SSCrazy

    Points: 2569

    Nice, simple question - good way to get the brain working after the weekend. Thanks! 🙂

  • Marcia J

    SSCertifiable

    Points: 5641

    dfortier (9/22/2014)


    Got me! 🙁

    Me, too. I'll blame it on a Monday morning brain.

  • Marcia J

    SSCertifiable

    Points: 5641

    JustMarie (9/22/2014)


    Made my guess, ran the code, got back NULL. Not an empty record set - NULL.

    So, did I. Even though that's what I answered, that's not what I was expecting since the explanation made sense to me.

    Can anyone explain why I would get something back?

    Running 2008 R2.

    Never mind. I see why. There are two select statements. The second one is doing a select on the variable @test which is null. That's the one that is returning a null value.

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

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