Precedence in math

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 bitbucket » Precedence in math

59 posts, Page 2 of 6

««1 2 3 4 5 »»»

Precedence in math

Rate Topic

Display Mode

Topic Options

Author

Message

Stuart Davies

Posted Thursday, January 10, 2013 1:30 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 9:13 AM
Points: 2,475, Visits: 2,134

Thanks for the question Ron. Easy point today and without the need for coffee Smile

-------------------------------
Posting Data Etiquette - Jeff Moden
Smart way to ask a question

There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx

Post #1405251

Hugo Kornelis

Posted Thursday, January 10, 2013 2:06 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 4:30 PM
Points: 5,235, Visits: 7,038

If this is an easy starter for a series of questions that gradually builds up, then it's sort of okay - though probably TOO easy.

As a stand alone question, I am not excited about it. The use of parentheses in all the queries means that there is no ambiguity anywhere, even for those who don't know the rest of the arithmetic precedence rules (and I would hope that almost everyone would get the question right even if there were no parentheses used in some of the queries).
Also, why use a blog post as the only reference, when a 5 second Google search would have given you this Books Online link?

Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

Post #1405274

call.copse

Posted Thursday, January 10, 2013 2:45 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 2:26 AM
Points: 1,084, Visits: 690

While it does appear to just test basic maths, I'd argue that doing an example without brackets is just annoying, and I'd be pretty displeased if debugging someone's SQL who had not bothered to put in some brackets for anything except basic addition / subtraction. Still I suppose something could have been done to spice it up, but I guess I'm not coming up with anything *shrugs*

Post #1405292

Stewart "Arturius" Campbell

Posted Thursday, January 10, 2013 3:32 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 3:48 AM
Points: 3,125, Visits: 4,311

Good back-to-basic mathematics question; Thanks, Ron

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Post #1405311

(Bob Brown)

Posted Thursday, January 10, 2013 4:41 AM

Say Hey Kid

Group: General Forum Members
Last Login: Friday, April 19, 2013 10:27 AM
Points: 690, Visits: 1,100

Thanks for easy one. Giving us the parens even made it easier.

Post #1405343

Thomas Abraham

Posted Thursday, January 10, 2013 5:09 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 5:02 AM
Points: 1,149, Visits: 1,451

Thank you Ron. I don't mind an easy question once in a while. Besides, I'm just paranoid enough to have looked it over an extra time to see if I was missing something. There's value in that too. Smile

Please don't go. The drones need you. They look up to you.

Post #1405350

Toreador

Posted Thursday, January 10, 2013 5:14 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, May 17, 2013 9:52 AM
Points: 1,356, Visits: 4,761

BODMAS

currently 7 wrong answers...

Post #1405353

paul s-306273

Posted Thursday, January 10, 2013 6:06 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, May 17, 2013 4:24 AM
Points: 1,158, Visits: 642

Wow, only 98% correct so far!

Post #1405375

mbova407

Posted Thursday, January 10, 2013 6:41 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, May 17, 2013 6:38 AM
Points: 1,327, Visits: 420

Nice attempt at the question, however I think this one is flawed

Seeing how result two does not need the parentheses that is

SELECT @A + (@B-@C) AS 'Result #2'

is the same as

SELECT @A + @B-@C AS 'Result #2'

And there is only one answer with 1 as the second option. The user can guess at the answer without understanding the concept

I would have thought

SELECT @A + @B * @C AS 'Result #4'

would have been more challenging without the parentheses for most people.

Post #1405395

Wayne Evans-440401

Posted Thursday, January 10, 2013 6:41 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 3:28 PM
Points: 108, Visits: 216

BODMAS :)

Edit: Shucks... Toreador, beat me to it.

OK PEMDAS BigGrin

Wayne

Did you get access denied? Great the security works.

Post #1405396

« Prev Topic | Next Topic »

59 posts, Page 2 of 6

««1 2 3 4 5 »»»

Permissions