

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%0 gives Msg 8134, Level 16, State 1, Line 1 Divide by zero error encountered.
So it seems you can use it to divide 0 by 0 and get an error.
Seriously?




Mr or Mrs. 500
Group: General Forum Members
Last Login: Thursday, April 23, 2015 2:05 PM
Points: 599,
Visits: 3,836


sknox (2/28/2011)
mtassin (2/28/2011) I got this right but...
SELECT 0%0
gives
Msg 8134, Level 16, State 1, Line 1 Divide 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




SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 10:48 AM
Points: 2,871,
Visits: 1,096


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




Hall of Fame
Group: General Forum Members
Last Login: Thursday, July 2, 2015 6:42 AM
Points: 3,688,
Visits: 72,448


mtillman921105 (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 DBA Proud member of the AntiRBAR alliance. For help with Performance click this link For tips on how to post your problems




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.




SSCoach
Group: General Forum Members
Last Login: Today @ 6:22 AM
Points: 18,775,
Visits: 17,015





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!




SSCommitted
Group: General Forum Members
Last Login: Today @ 2:48 AM
Points: 1,989,
Visits: 7,198


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 = 2 means roughly the same as 8 = 2 (mod 6) or more accurately 8 ≡ 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 )




SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 2:21 PM
Points: 1,647,
Visits: 2,307


Ambiguity in the question..!
Answer should be both..
(1) divide by zero/ (2) remainder.
Thanks.




Mr or Mrs. 500
Group: General Forum Members
Last Login: Thursday, April 23, 2015 2:05 PM
Points: 599,
Visits: 3,836


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



