Fancy collations 😛 Tomorow morning in Bois de Boulogne 😀

Nice constructor. Alas we are limited by older version.

Once upon a time I had a dream to write a QotD with a correct answer "It depends". I succeeded.

Now I'm going to imagine one with two answers "All of...

I propose to switch the answers #4 and #5. The answer All of above becomes correct in this order.

Of course not. The rainbow table is not created by leprechaun, they only use it to hide...

Leprechauns :hehe:

L' Eomot Inversé (1/4/2012)

---

It's not stuff because it's a verb not a noun. To hexadecimal is to cast a...

Thank You, nice one.

Took a while, but it was easy. 2011%16 > 1, there was just one answer.

Now I wait three weeks for the beginning of the year of dragon.

Hugo Kornelis (12/6/2011)

---

Absolutely true. This...

Hugo Kornelis (12/6/2011)

---

honza.mf (12/6/2011)

---

Hi!

I don't understand how the condition AND o.OrderDate > DATEADD(month, -4, CURRENT_TIMESTAMP) in SQL Query #4 works. For me it seems it...

Hi!

I don't understand how the condition AND o.OrderDate > DATEADD(month, -4, CURRENT_TIMESTAMP) in SQL Query #4 works. For me it seems it is to eliminate...

Hugo Kornelis (10/24/2011)

---

PS: There's even one more way to achieve the intended change:

UPDATE TOP(1) Table1

SET Column1 = 0

WHERE Column1 = 1;

Since row order in a relational...

Don't you miss it? And even no complaints on wording and explanation. :hehe:

I must say (after the coffee and a lunch), that this question is educational in two ways

- datetime and between

- careful reading of code

So I conclude the question is little...

A little bit tricky. For me it's impossible to notice the reverted order of assignments before a coffee.