Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

Author
 Message
 Posted Monday, February 28, 2011 9:08 AM
 Ten Centuries Group: General Forum Members Last Login: Thursday, January 31, 2013 8:01 AM Points: 1,228, Visits: 1,046
 mtassin (2/28/2011)I got this right but...SELECT 0%0givesMsg 8134, Level 16, State 1, Line 1Divide by zero error encountered.So it seems you can use it to divide 0 by 0 and get an error.Seriously?
Post #1070609
 Posted Monday, February 28, 2011 9:17 AM
 SSChasing Mays Group: General Forum Members Last Login: Friday, January 22, 2016 2:15 PM Points: 600, Visits: 3,852
 sknox (2/28/2011)mtassin (2/28/2011)I got this right but...SELECT 0%0givesMsg 8134, Level 16, State 1, Line 1Divide by zero error encountered.So it seems you can use it to divide 0 by 0 and get an error.This makes sense, since a modulus can be defined as a product of division, you have to be able to do the division. Some systems, though, define x mod 0 as x (i.e, the difference between x and the nearest multiple of 0 [which is 0 (because 0 is the only multiple of 0.)])Yeah, I just included the "To divide by zero and get an error" as a joke. If you look at the symbol and take it at face value, that's what the symbol looks like.p.s. To be more clear, it looks like a small zero divided by zero: 0/0. ______________________________________________________________________The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
Post #1070618
 Posted Monday, February 28, 2011 9:29 AM
 Hall of Fame Group: General Forum Members Last Login: Tuesday, November 22, 2016 10:06 AM Points: 3,071, Visits: 1,130
 I feel so silly for selecting the wrong answer - which was so obviously wrong..I am humbled. Thank goodness it's Monday so I can blame something
Post #1070622
 Posted Monday, February 28, 2011 9:54 AM
 Hall of Fame Group: General Forum Members Last Login: Friday, September 16, 2016 12:22 PM Points: 3,849, Visits: 72,507
 mtillman-921105 (2/28/2011)Yeah, I just included the "To divide by zero and get an error" as a joke. If you look at the symbol and take it at face value, that's what the symbol looks like.p.s. To be more clear, it looks like a small zero divided by zero: 0/0.Gotta be careful with jokes... as I said, I got this one right.But somebody else could have said "Hey if I modulus 0 by 0 I get a divide by zero error!" and selected the last option, not realizing you were referring to what the % sign looks like. :) --Mark Tassin MCITP - SQL Server DBAProud member of the Anti-RBAR alliance.For help with Performance click this linkFor tips on how to post your problems
Post #1070636
 Posted Monday, February 28, 2011 9:59 AM
 Ten Centuries Group: General Forum Members Last Login: Thursday, January 31, 2013 8:01 AM Points: 1,228, Visits: 1,046
 mtassin (2/28/2011)[quote]But somebody else could have said "Hey if I modulus 0 by 0 I get a divide by zero error!" and selected the last option, not realizing you were referring to what the % sign looks like.Which would mean nothing unless they could find documentation supporting the obvious wrong answer. It was a multiple choice question with one right answer. Test taking 101 tells us to select the answer that is MOST correct.That was answer 3.I like it when there are joke answers that are funny IF you understand the questions, or what you are reading. It has been proven that these questions improve learning.
Post #1070640
 Posted Monday, February 28, 2011 12:52 PM
 SSC-Insane Group: General Forum Members Last Login: Today @ 2:52 PM Points: 20,083, Visits: 18,257
 thanks for the question - straight forward. Jason AKA CirqueDeSQLeilI have given a name to my pain...MCM SQL Server, MVPSQL RNNRPosting Performance Based Questions - Gail Shaw
Post #1070771
 Posted Monday, February 28, 2011 1:15 PM
 SSCrazy Group: General Forum Members Last Login: Tuesday, June 30, 2015 9:47 AM Points: 2,160, Visits: 2,204
 Thanks for the nice easy start to the week!
Post #1070787
 Posted Tuesday, March 1, 2011 2:25 AM
 SSCrazy Group: General Forum Members Last Login: Wednesday, November 30, 2016 2:06 AM Points: 2,251, Visits: 8,029
 SanDroid (2/28/2011)So happy that over 80 percent of us know math.Can you imagine how hard it would be a SQL developer or DBA if you didn't learn higher level math?What's maths got to do with it? The use of % for modulo is a computing term. The mathemetical equivalent would be 'mod', though it's meaning is similar rather than identical.eg 8 % 6 = 2means roughly the same as 8 = 2 (mod 6)or more accurately8 ≡ 2 (mod 6)(note it's 25 years since I graduated so I'm probably about to be humilated when someone points out that I'm talking nonsense )
Post #1071046
 Posted Tuesday, March 1, 2011 2:17 PM
 SSCrazy Group: General Forum Members Last Login: Yesterday @ 3:31 PM Points: 2,270, Visits: 3,117
 Ambiguity in the question..!Answer should be both..(1) divide by zero/ (2) remainder. Thanks.
Post #1071589
 Posted Tuesday, March 1, 2011 2:24 PM
 SSChasing Mays Group: General Forum Members Last Login: Friday, January 22, 2016 2:15 PM Points: 600, Visits: 3,852
 OK, the next time I submit a question, I'll be sure that the fluke answer, if there is one included, can in no way be misconstrued as a possible right answer.I think some of you are used to trick questions, so you're looking for a sneaky answer. ______________________________________________________________________The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
Post #1071595

 Permissions