Toreador (8/15/2013)

---

Good question, though even if you didn't know the answer the "choose 4" hints should give it away - I guess the 50% (!) getting it wrong didn't notice...

L' Eomot Inversé (7/17/2013)

---

The reason that you can't use return with a value in a batch is that batches don't return scalar values, they return (possibly empty) result sets or...

<sarcasm>

I don't think I understand entirely how the explanation was wrong. Can someone else (or maybe 10 more people) please chime in and explain exactly what was so incorrect about...

I think a lot of people might have mistaken...

ztoddw (6/27/2013)

---

Those who assumed something from the title... remember when you assume what it makes out of "u" and "me"... 🙂

Most of you also assumed that "running correctly" meant the...

L' Eomot Inversé (6/17/2013)

---

Richard Warr (6/17/2013)

---

As only 6% selected the wrong answer it must be down to not selecting three options. If you...

Carlo Romagnano (6/7/2013)

---

I disagree...

Mike Dougherty-384281 (6/6/2013)

---

Why is this question about IIF broken because of the case sensitivity issue?

What real code would ever use varchar(1)?

Was the extra space in the varchar(4) field supposed...

SQLRNNR (6/5/2013)

---

Wow - talk about DBCC Timewarp and some wormhole effect.

Reason being that the same question was for June 3 and June 8. Answer one and both get ticked...

Does anyone know why this question now shows in the question list as Jul 8, 2013? Seems like this kind of thing happens occasionally here.

Very good question, thank you Mr. Ocean!

I didn't know about this behaviour, but giving it some thought before answering made me realize the right answer.

Also, thank you Hugo for the...

Mike Dougherty-384281 (5/3/2013)

---

"a table which has one column with identity property"

I read the question incorrectly as "a table with one column additional to the identity column"

it's not an excuse; just...

You can eliminate options 1 and 2 because they don't name the second result column as IsAvailable, as it is shown in the desired output.

Of course, I wasn't sure if...

John Mitchell-245523 (4/18/2013)

---

To generalise, if you have n tables Table1, Table2, ... , Tablen where for each value of k Tablek has k rows populated with values 1,2,...,k:

The COUNT is...

Got it right by elimination. There is no way a NULL value would be converted to an actual date (as far as I know, at least), so that eliminates answer...