Viewing 15 posts - 61 through 75 (of 89 total)
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...
June 28, 2010 at 4:04 am
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...
April 28, 2010 at 3:53 am
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...
April 22, 2010 at 2:24 am
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...
March 11, 2010 at 2:31 am
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...
March 5, 2010 at 3:23 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...
March 3, 2010 at 3:38 am
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...
March 2, 2010 at 2:29 am
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...
February 22, 2010 at 2:52 am
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...
January 29, 2010 at 2:28 am
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...
January 28, 2010 at 4:32 am
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...
January 28, 2010 at 2:24 am
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...
January 20, 2010 at 3:27 am
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...
January 5, 2010 at 2:50 am
Yes, my mistake Dietmar! I think I was half-asleep!
Ken.
November 9, 2009 at 2:11 am
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...
November 8, 2009 at 5:01 am
Viewing 15 posts - 61 through 75 (of 89 total)