Glad to see I'm not alone in deciding immediately that answer #3 with DateOfLeaving DESC wouldn't put the dates in the right order so is definitely wrong, irrespective of where...

I think the explanation of the answer is wrong. It says

If any value meets these criteria, then TRUE is returned to the IF statement and it is true in this...

But the problem is that if someone reads this QOD and answer, without reading the discussion, and then tries...

I got this right because I knew UPDATETEXT and WRITETEXT were deprecated, but didn't realise that UPDATE SET ... .WRITE ... doesn't actually work with TEXT datatypes.

/*------------------------

create table #t (xx...

I think 6 point for this was a bit much since I beleive the correct answer should have been 'None of the above', but I had to enter one answer.

1....

This thread is getting so long I had to go back and check what the original question was! 🙂

The definition of quality that I've always...

webrunner (5/20/2008)

---

James Goodwin (5/20/2008)

---

webrunner,

Change that to varchar(8) and it will work.

'20080520AB' cannot be converted to a date, but...

webrunner (5/20/2008)

---

SQL may be correct...

GSquared (5/20/2008)

---

Derek Dongray (5/20/2008)

---

If T-SQL allowed VARCHAR(*) in the declaration, you could declare a UDF which would accept a VARCHAR of any size without truncating it and it wouldn't need...

I got this wrong, because I didn't stop and think, as I've actually encountered it in the past and now always declare VARCHAR parameters as larger than I expect.

Of course,...

davidthegray (5/15/2008)

---

I wonder why, although I chose the correct answer (I doublechecked with the back button), it says "You are wrong". And the precentages show total much more than 100%....

Carla Wilson (5/14/2008)

---

This syntax includes the WITH "CTE" syntax, and on this page, the SELECT statement shows the FROM clause as optional! Perhaps when CTEs were introduced in SQL...

Matt Marston (5/14/2008)

---

After looking at the execution plan it appears that SQL Server filtered the customer rows based on the WHERE clause of the subselect of the IN clause. This...

I got this wrong, but it then took me some time to work out what the right answer meant. In fact, I still cannot understand it and would like someone...

majorbloodnock (5/8/2008)

---

I've just realised. If someone reports a SQL Server bug to Microsoft, they can post it as a QOTD to see how much of a problem it is....

Question: You're...