Select Statement

Question

Select Statement

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

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

TomThomson SSC Guru Points: 104773 More actions · Answer 1

Revenant (5/22/2012)
Too easy, and I am surprised that there is any discussion...

You've obviously never followed comp.sci.maths. The strange ideas I've seen here from a couple of contributors pale into insignificance beside the abject idiocy and pig-headed refusal to accept logic that is commonly displayed there (or perhaps "was" not "is" - it got so bad that I gave up following it years ago). I've even had to correct the odd insanity in wikipedia maths articles, although those probably arise because the same sort of nutter that polluted comp.sci.maths decided to edit maths articles on wikipedia. It's quite reasonable for someone with no real formal maths (and in particular no real type theory) to fail to distinguish between a general number type and distinct integer and decimal and float types; or understand why what they would find nice is in conflict with what allows the rest of us to be rigorous in our use of types.

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

edit: geve -> gave

Tom

TomThomson SSC Guru Points: 104773 More actions · Answer 2

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

Revenant SSC-Forever Points: 42467 More actions · Answer 3

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? 😉

Paul White SSC Guru Points: 150467 More actions · Answer 4

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 🙂

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Rose Bud Hall of Fame Points: 3147 More actions · Answer 5

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.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

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

Toreador SSChampion Points: 11360 More actions · Answer 7

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 😉

Britt Cluff SSCertifiable Points: 5083 More actions · Answer 8

Good back to basics question. Thanks for submitting.

http://brittcluff.blogspot.com/

Neha05 Default port Points: 1494 More actions · Answer 9

Neha05

Default port

Points: 1494

August 9, 2012 at 8:59 am

#1523857

Back to basics question.