SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Mark Tillman / The Percent Sign in T-SQL / Latest Posts

RE: The Percent Sign in T-SQL

zymos — Fri, 02 Mar 2012 15:11:09 GMT

Good question and thank you.

RE: The Percent Sign in T-SQL

Toreador — Wed, 02 Mar 2011 02:08:41 GMT

[quote][b]SanDroid (3/1/2011)[/b][hr]Tell me what the "≡" is and we will use wet noodles for the beating. :w00t:[/quote]"Is equivalent to", or "is exactly the same thing as"(Stronger than '=')

RE: The Percent Sign in T-SQL

Koen Verbeeck — Wed, 02 Mar 2011 00:17:34 GMT

[quote][b]SanDroid (3/1/2011)[/b][hr][quote][b]Toreador (3/1/2011)[/b][hr][quote]or more accurately8 ≡ 2 (mod 6)[/quote]Tell me what the "≡" is and we will use wet noodles for the beating. :w00t:[/quote]It can mean a lot of things, but usually it is a strong indicator of equality or identity.[url]http://en.wikipedia.org/wiki/Triple_bar[/url][url]http://en.wikipedia.org/wiki/List_of_logic_symbols[/url][url]http://en.wikipedia.org/wiki/Congruence_relation[/url][url]http://en.wikipedia.org/wiki/Equals_sign[/url]

RE: The Percent Sign in T-SQL

SanDroid — Tue, 01 Mar 2011 14:33:29 GMT

[quote][b]Toreador (3/1/2011)[/b][hr][quote]or more accurately8 ≡ 2 (mod 6)[/quote]Tell me what the "≡" is and we will use wet noodles for the beating. :w00t:

RE: The Percent Sign in T-SQL

SanDroid — Tue, 01 Mar 2011 14:30:05 GMT

[quote][b]mtillman-921105 (3/1/2011)[/b][hr]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 me misconstrued as a possible right answer.I think some of you are used to trick questions, so you're looking for a sneaky answer.[/quote]LOL... Perhaps we should also put in hints like.... "This is not the right answer" "Don't click this for points" "j/k" "Check this answer to win!"I saw nothing wrong with your question and understand a math joke when I read one. I liked your question, please do not change it at all.It tested much more than peoples knowledge of SQL and questions that can do that are priceless.

RE: The Percent Sign in T-SQL

mtillman-921105 — Tue, 01 Mar 2011 14:24:43 GMT

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.

RE: The Percent Sign in T-SQL

SQL-DBA-01 — Tue, 01 Mar 2011 14:17:51 GMT

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

RE: The Percent Sign in T-SQL

Toreador — Tue, 01 Mar 2011 02:25:55 GMT

[quote][b]SanDroid (2/28/2011)[/b][hr]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?[/quote]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 :-))

RE: The Percent Sign in T-SQL

UMG Developer — Mon, 28 Feb 2011 13:15:08 GMT

Thanks for the nice easy start to the week!

RE: The Percent Sign in T-SQL

SQLRNNR — Mon, 28 Feb 2011 12:52:37 GMT

thanks for the question - straight forward.

RE: The Percent Sign in T-SQL

SanDroid — Mon, 28 Feb 2011 09:59:53 GMT

[quote][b]mtassin (2/28/2011)[/b][hr][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.[/quote]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.

RE: The Percent Sign in T-SQL

mtassin — Mon, 28 Feb 2011 09:54:23 GMT

[quote][b]mtillman-921105 (2/28/2011)[/b]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.[/quote]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. :)

RE: The Percent Sign in T-SQL

BarbW — Mon, 28 Feb 2011 09:29:17 GMT

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 :-D

RE: The Percent Sign in T-SQL

mtillman-921105 — Mon, 28 Feb 2011 09:17:42 GMT

[quote][b]sknox (2/28/2011)[/b][hr][quote][b]mtassin (2/28/2011)[/b][hr]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.[/quote]:-)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.)])[/quote]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.

RE: The Percent Sign in T-SQL

SanDroid — Mon, 28 Feb 2011 09:08:55 GMT

RE: The Percent Sign in T-SQL

SanDroid — Mon, 28 Feb 2011 09:05:57 GMT

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?

RE: The Percent Sign in T-SQL

sknox — Mon, 28 Feb 2011 08:41:42 GMT

[quote][b]mtassin (2/28/2011)[/b][hr]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.[/quote]:-)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.)])

RE: The Percent Sign in T-SQL

mtassin — Mon, 28 Feb 2011 08:02:06 GMT

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.

RE: The Percent Sign in T-SQL

anders-731262 — Mon, 28 Feb 2011 04:05:53 GMT

Thanks.It would have been nice to have a shortcut for 0/0 (divide zero by zero) :-).

RE: The Percent Sign in T-SQL

DugyC — Mon, 28 Feb 2011 02:52:31 GMT

Nice easy one to start of the week, cheers. :-D

RE: The Percent Sign in T-SQL

Koen Verbeeck — Mon, 28 Feb 2011 01:36:45 GMT

Nice and easy, good for a Monday morning. Thanks.

RE: The Percent Sign in T-SQL

Iulian -207023 — Mon, 28 Feb 2011 01:04:28 GMT

easy one, thanksIulian

RE: The Percent Sign in T-SQL

tejaswini.patil — Sun, 27 Feb 2011 23:46:33 GMT

Thanks for easy question. :-)

RE: The Percent Sign in T-SQL

mohammed moinudheen — Sat, 26 Feb 2011 22:57:45 GMT

Easy one :-D

The Percent Sign in T-SQL

mtillman-921105 — Sat, 26 Feb 2011 22:57:17 GMT

Comments posted to this topic are about the item [B]The Percent Sign in T-SQL[/B]