May 22, 2012 at 10:47 am
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
May 22, 2012 at 11:05 am
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? 😉
May 22, 2012 at 11:28 am
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 🙂
May 22, 2012 at 11:39 am
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.
May 22, 2012 at 8:37 pm
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
May 23, 2012 at 1:53 am
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 😉
May 24, 2012 at 7:36 pm
Good back to basics question. Thanks for submitting.
http://brittcluff.blogspot.com/
August 9, 2012 at 8:59 am
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