Hawk(e)

Yes, a good one. And in the last 6 hours the wrong rate has grown from 19% to 27%, which...

Koen Verbeeck (12/18/2012)

---

And from me too, best wishes of the season to everyone.

Nice easy one today.

Perhaps it would have been a good idea to provide the appropriate BoL reference: CREATE FUNCTION (Transact-SQL) which contains the statement

In multistatement table-valued functions, @return_variable is...

Hugo Kornelis (12/17/2012)

---

(That being said - there is indeed no guarantee. SQL Server could come up with an execution plan that projects the SELECT list first, then reorders the rows....

Mosty a good question, apart from the awful misprint - the table would not be created unless that was corrected!

To all those talking about select being atomic: that's nonsense. ...

Good question.

I managed to misread the code and got it wrong (with a "none of the above answer", because I thought the firsttwo inserts were both to the first table,...

Excellent question.

Hugo Kornelis (12/12/2012)

---

If you follow the links in my previous post and compare the navigation panes to the left, you'll see that the SQL2008 version includes GROUPING_ID in an alphabetic...

A good idea badly executed is a good description of this question.

If you exactly...

Interesting question.

I picked the same wrong answer (set up but not started) as 45% of those who answered before me, so I've learnt something.

DavidBridgeTechnology.com (12/11/2012)

---

I 100% agree with all of you who commented on my earlier post.

Please note though..

Pedantically, NULL is not nothing but I said this in the descriptive rather than the...

It's an interesting question,

But it also brings up a rather nasty fact about the language - a gaping whole in the whole idea that NULL is NULL, not somethink like...

Interesting question, but needs a bit more statement of conditions to make it a perfect question. It needs to specify that the table doesn't already exist in the the...

Wrong meaning...