Forum Replies Created

Viewing 15 posts - 61 through 75 (of 89 total)

  • RE: What will be the output of the following?

    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...

  • RE: Date data type

    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...

  • RE: Truncate rollback

    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...

  • RE: What's the count?

    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...

  • RE: How many rows are returned from the query below?

    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...

  • RE: How many rows are returned from the query below?

    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...

  • RE: Numeric or Not Numeric

    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...

  • RE: Numeric or Not Numeric

    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...

  • RE: Rowcount

    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...

  • RE: Query cost

    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...

  • RE: Query cost

    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...

  • RE: Predict output

    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...

  • RE: Dynamic SQL

    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...

  • RE: More Fun With NULL

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

    Ken.

  • RE: More Fun With NULL

    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...

Viewing 15 posts - 61 through 75 (of 89 total)