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.

sknox (2/28/2011)

---

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.)])

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.

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.

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?