Exponent Engima

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by RBarryYoung » Exponent Engima

53 posts, Page 1 of 6

1 2 3 4 5 »»»

Exponent Engima

Rate Topic

Display Mode

Topic Options

Author

Message

RBarryYoung

Posted Wednesday, August 06, 2008 10:09 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 11:17 AM
Points: 9,855, Visits: 9,376

Comments posted to this topic are about the item Exponent Engima

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #547995

hodgy

Posted Thursday, August 07, 2008 2:07 AM

SSCommitted

Group: General Forum Members
Last Login: Thursday, June 13, 2013 2:48 AM
Points: 1,865, Visits: 557

Oh, I fell for that one. good question, highlighting an incorrect assumption of mine (I neither use exponents nor bitwise XORs on a regular basis).

Thanks, Tom

Life: it twists and turns like a twisty turny thing

Post #548066

Christian Buettner-167247

Posted Thursday, August 07, 2008 2:38 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 12:36 AM
Points: 2,547, Visits: 3,648

What a nasty question... :P
Is this standard SQL behaviour or just MS style?

Best Regards,
Chris Büttner

Post #548082

skyline666

Posted Thursday, August 07, 2008 3:25 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, September 24, 2008 1:27 PM
Points: 350, Visits: 229

Got it right Cool

. Out of interest, what was the "@b bigint" for, to try and confuse people with the @b-17 answer :D?

Post #548106

Sorin Petcu

Posted Thursday, August 07, 2008 4:18 AM

SSChasing Mays

Group: General Forum Members
Last Login: Monday, April 29, 2013 7:32 AM
Points: 620, Visits: 267

what a glitch!!

in BOL it says that SQRT ( float_expression )
and float could be, as definition of float,
float - 1.79E+308 to -2.23E-308, 0 and 2.23E-308 to 1.79E+308
so, where it says that the argument of SQRT should be not negative!???

In Theory, theory and practice are the same...In practice, they are not.

Post #548139

hodgy

Posted Thursday, August 07, 2008 4:26 AM

SSCommitted

Group: General Forum Members
Last Login: Thursday, June 13, 2013 2:48 AM
Points: 1,865, Visits: 557

i think it is more a case of sql server probably not being able to handle complex numbers (the square root of a negative number).

Life: it twists and turns like a twisty turny thing

Post #548149

Sorin Petcu

Posted Thursday, August 07, 2008 4:44 AM

SSChasing Mays

Group: General Forum Members
Last Login: Monday, April 29, 2013 7:32 AM
Points: 620, Visits: 267

yeah, but the question was from TSQL category. so, it supposed to be on sql issue and not sql server engine issue.

In Theory, theory and practice are the same...In practice, they are not.

Post #548161

RBarryYoung

Posted Thursday, August 07, 2008 7:28 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 11:17 AM
Points: 9,855, Visits: 9,376

hodgy (8/7/2008)

Oh, I fell for that one. good question, highlighting an incorrect assumption of mine (I neither use exponents nor bitwise XORs on a regular basis).

Thanks, Tom

Thanks Tom. Yeah, hardly anyone does in SQL server, so that was the hidden corner I was aiming for.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #548276

RBarryYoung

Posted Thursday, August 07, 2008 7:34 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 11:17 AM
Points: 9,855, Visits: 9,376

Christian Buettner (8/7/2008)

What a nasty question... :P
Is this standard SQL behaviour or just MS style?

Standard ANSI SQL. The key is that "^" is NOT the exponent operator as many (including myself) have assumed and as it is in VB. Rather it is the bitwise XOR operator, as in C#, which of course gives completely different results. That is standard ANSI.

Square Root functions require non-negative inputs in virtually every production language ever, except those that have built-in complex numbers, like Fortan and ADA.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #548284

rudy - Doctor "X"

Posted Thursday, August 07, 2008 7:42 AM

Hall of Fame

Group: General Forum Members
Last Login: Friday, May 17, 2013 2:11 PM
Points: 3,108, Visits: 2,114

Cool question - I have not had to think about complex numbers, a+bi, since high school !

Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."

Post #548291

« Prev Topic | Next Topic »

53 posts, Page 1 of 6

1 2 3 4 5 »»»

Permissions