+1

The next one should be -

Which one is not a fruit:

a. banana

b. apple

c. orange

d. They are...

+57 - Trying to not be as grandious as Koen's later +1000 🙂

Knew when I saw the question I had very little chance to get it right, because none...

Kenneth, thanks for the question. Everyone says back to basics question. Basically, it wasn't for me, as I've never even seen code (mine or anyone else's that used this.). Got...

Nakul Vachhrajani (10/31/2012)

---

Very nice question! With a little thought, I was certain about the answer. While this was the first time I heard about "halloween protection", the chain of thought...

Thanks for the question. A basic but clear one. Just right for a Friday. More?

Any chance we could get Hugo to rewrite BOL, so they are correct and useful? Thanks for the, as usual, great explanation.

Edited to correct punctuation.

And that's why...

Primo Dang (10/17/2012)

---

Thanks for the question! =]

For a moment, I thought either COALESCE or ISNULL interpreted 'NULL' as NULL and that was the point of the question, but I decided...

Thanks for the question. I was kind of expecting something like this after the first question. Natural follow on to it.

Great question. Thanks for posting. The question should be easy, but apparently isn't for some.

Is it Monday? This is a basic programming principle - counter incremented at end of while loop. Thanks for posting - I need the points.:hehe:

Same here. I thought that it wouldn't...

Nice question, kind of related to the earlier discussion on language in the detour two days ago instigated by Tom's ever-evolving sig line.

L' Eomot Inversé (10/2/2012)

Two things there: 1) It isn't Irish (neither gaeilge nor gaoluinn), it's gàidhlig (scottish gaelic - which Google Translate currently doesn't support at all, although plenty of...

Thanks for the question Amit. Surprised that 19% (as of now) got this wrong. I can see not getting some of the less frequently used features of T-SQL. But, joins...