Very nice question. Nice SQL inject with a side effect.

I hope I will never use something like this one.

bitbucket-25253 (2/1/2010)

---

What we do not know is how many answer incorrectly, and do NOT post a moan and groan, but DO LEARN something which in the future will be of...

Christian Buettner-167247 (2/1/2010)

---

Well, you got me - I confess - I cheated at least once in the QotDs.

But that is probably true for most of us - sometimes we just...

paul.goldstraw (2/1/2010)

---

It seems to be happening more and more at the moment and it makes me wonder how many of the people who get the answer right in any QotD...

danemery (1/29/2010)

---

If one has to connect first in order to to run the t-sql statements, the correct answer should be 1,1. If a theoretical question is being asked with no...

bitbucket-25253 (1/29/2010)

---

I would add to kaspencer's statement, the following addition: test, test and test again your proposed submission before submitting. Let a few days pass and retest,...

And back again: What about trying the script by editors?...

As to suggestions about trying against different versions, bear in mind that the question might have been contributed by someone without easy access to anything above 2000 or may have...

And what about the answer "Any number, 1" or better "Nonnegative number, 1".

This is correct in all situations and after any scripts run in the past by the same connection.

Just another QotD with correct answer that is correct only in some settings.

I wrote only one question (I am lazy), but I tried the script on more versions of SQL...

mike.anderson 52709 (1/27/2010)

Trying this out, I still get execution plans that are on the face of it identical (they must be different, because the result sets are different); the cost...

mike.anderson 52709 (1/27/2010)

---

honza.mf (1/27/2010)

---

CirquedeSQLeil (1/27/2010)

---

honza.mf (1/27/2010)

---

I answered OK, but...

The first variant with IN can be more effective, it allways depend on data. Compare two queries without any knowledge about structure...

CirquedeSQLeil (1/27/2010)

---

honza.mf (1/27/2010)

---

I answered OK, but...

The first variant with IN can be more effective, it allways depend on data. Compare two queries without any knowledge about structure of tables, indexes,...

I answered OK, but...

The first variant with IN can be more effective, it allways depend on data. Compare two queries without any knowledge about structure of tables, indexes, possible data...

As far as I know, NULLs and empty strings are equal in Oracle. But in SQL...