I was convinced that I knew the answer (-1, 0, 1 NB not -0), and so selected that one. And then you reported that I was wrong. Along with...

That question revealed quite a significant difference between SQL Server 2005 and 2008.

With SQL Server 2005, the datatype DATE is not valid, and so if the datatype of the variable...

The insert statement has a syntax that is unacceptable to SQL Server 2005. So why wasn't it stated as being compatible with SQL Server 2008 and later only?

We should get...

That's is a good question, illustrating the need for careful joins!

For those that don't know, this kind of result is called a "cartesian product", and if you allow it to...

I think that I am probably one of those who has been criticised in this thread because I have complained about a number of the questions written for SQLServerCentral.

I am...

OBJECTION! OBJECTION! OBJECTION!

Yet another useless question.

I knew I had no table named "tblUsers", and so I answered "Error Message".

And I was correct - that was the answer I got.

I demand...

Ah, yes, maybe, Kelsey.

BUT if you are going to call it the "decimal point", then there is only only one punctuation symbol that resembles a point, and that is...

Good question. And it also raises a further point in my mind ...

Is there a need to standardise numerical representation across every locale ?

I ask this because, in some...

Well, well, well, yet another complaint about a QotD, and I am not the only one!

Like so many others, I was inclined to go for 0,1 but I just thought...

SWOne: thanks for the reply.

However, if you look at an unanswered question (next time), you will see that it is actually quite difficult (no doubt deliberately) to read a...

I wanted to choose Query 2 as the correct query.

However, I had three options from which to make my choice, the first and third being "Wriong answer" and the second...

OK OK OK, so here I am once again complaining!

When I studied this question, I thought: "Well, the only values inserted into the table, will be 1, 2, 4 and...

I couldn't see the answer to this question, and so I guessed "C" which happened to be correct.

However, when I tried the three options on my system, "C" returned an...

Yes, my mistake Dietmar! I think I was half-asleep!

Ken.

Interesting answer.

I tried this without looking anything up, and got some of it wrong.

Then I ran the queries ... and in my case, the queries that were stated as failures...