Select Statement

  • Good question. Pity about the explanation. But please keep producing questions like this - thanks for this one.

    Thanks to Hugo too, for some very good comments; and to Paul for his.

    Tom

  • L' Eomot Inversé (5/22/2012)


    . . . The really scary thing is that more than 10% of people responding up to now got it wrong. They don't know what SQL's / operator does. . . .

    Let's hope they learned it. But who needs math operators, anyway? 😉

  • archie flockhart (5/22/2012)


    But to reply to Paul's direct question and to your list of possible results above: if I could choose, I'd return FLOAT data.

    Fair enough, that's an arguably good choice. It would also make for some interesting QotD questions 🙂

  • Thomas Abraham (5/22/2012)


    ...and writing reports that won't be looked at when the crisis of the moment is over...

    I thought that was my job!

    Interesting that the most basic of questions can initiate a stimulating discussion.

  • Koen Verbeeck (5/21/2012)


    Too easy 😀

    Yes it was.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • L' Eomot Inversé (5/22/2012)

    The really scary thing is that more than 10% of people responding up to now got it wrong. They don't know what SQL's / operator does

    I only knew the answer because of previous QotDs. I can't think of any time that I've wanted or needed to do any division (or indeed any arithmetic) using integer types rather than floats. Or perhaps I have, and nobody's ever noticed that it's not working 😉

  • Good back to basics question. Thanks for submitting.

    http://brittcluff.blogspot.com/

  • Back to basics question.

Viewing 8 posts - 31 through 38 (of 38 total)

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