Got it right, even though the correct answer isn't listed. But I guessed rightly that the author assumed we all use US date formats 😉

SanDroid (9/14/2011)[hrIf you can't handle the heat of discussion about content you post on the internet then don't submit it. If you make a mistake in front of a...

Good idea.

But how many points should people...

A good question, unfortunately it came down to "guess the typo". Fortunately I guessed right that the values inserted into cuss2 were supposed to be the same as those inserted...

As with the others in this series, I didn't have the foggiest idea, so wrongly guessed that it would be the answer not already used by the other 2 questions...

cengland0 (9/6/2011)

---

Tee Time (9/6/2011)

---

The most commonly selected answer (so far) is "Query 3 and Query 4 will fail" (28%) which means many people think it's okay to put an order...

"If you got this wrong, it means you are new to SQL Server as the people other than James Franco and Hugh Hefner are some of the luminaries in the...

There was nothing in the question that told me the code had to be run using SQLServer. I wrote it down on a piece of paper and nothing happened. Can...

Emphasis mine 😉

That one at least is not true. I wondfer how many of your other statements are also wrong?

Worth staying subscribed for 🙂

and breathe....

I didn't have the foggiest, so am one of the 60% who guessed wrongly that it wouldn't increase!

I've never had to work with a database that did anything other than...

Tom.Thomson (8/4/2011)

---

I've always found it a bit disappointing that IsNumeric(Null) doesn't return NULL; after all, a NULL value doesn't contain any non-numeric characters, so it's not not numeric; and it...

So if Microsoft are correct to claim that this is by design, then presumably they would acknowledge all the counter-examples provided by SQLkiwi as bugs?

P.S. I wonder how many of...