Forum Replies Created

Viewing 15 posts - 2,761 through 2,775 (of 3,348 total)

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

    lbrigham (6/28/2010)


    or did someone else already mention this?

    :rolleyes:

    Aaron N. Cutshall (6/28/2010)


    However, I also perceive that folks feel a need to post a comment here in order to get their points...

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

    Preet_S (6/28/2010)


    There does seem to be an obsession with points, but if a question is posted it should at least be "right".

    Agreed. But on the other hand, writing these questions...

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

    tomasiranek (6/28/2010)


    Someone made a typo - correct answer for that sample is -1, 0, 1 - no doubt.

    So give us points and take out points to author of this QoD...

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

    david.wright-948385 (6/28/2010)


    Anyone here think QoD questions and answers should be checked independently before they are released?

    @david-2 - that has been suggested before. On numerous occasions. And several people have volunteered...

  • RE: "SELECT @local_variable"

    UMG Developer (6/25/2010)


    Hugo KornelisI did read your post, but the Connect item you linked to was not what I meant when I wrote that I knew this to be documented...

  • RE: "SELECT @local_variable"

    Ninja's_RGR'us (6/25/2010)


    Hugo Kornelis (6/25/2010)


    kevin.l.williams (6/25/2010)


    Hugo Kornelis (6/25/2010) Is 0.1% chance of incorrect results acceptable for your user?

    Not for me.

    Hugo, is this the article you were looking for?

    "The correct...

  • RE: "SELECT @local_variable"

    JF1081 (6/25/2010)


    Why is the answer 'C'? Could it be possible that the query would return 'A' or 'B'?

    Possible? I'd say yes, because the results of this kind of query...

  • RE: "SELECT @local_variable"

    kevin.l.williams (6/25/2010)


    Hugo Kornelis (6/25/2010) Is 0.1% chance of incorrect results acceptable for your user?

    Not for me.

    Hugo, is this the article you were looking for?

    "The correct behavior for an...

  • RE: "SELECT @local_variable"

    OCTom (6/25/2010)


    An unsupported technique? I have seen this used and have been encouraged to use this technique by an experienced consulted. I'll be sending him the link to this discussion....

  • RE: "SELECT @local_variable"

    Though the explanation sounds enlightening, it is wrong. And it is also wrong to claim that the result of this query will always be "C".

    Though many people seem to prefer...

  • RE: coalesce and nullif

    forjonathanwilson (6/23/2010)


    null date can be cast as null string, but not the other way, interesting.:hehe:

    This is not correct. A null string can be cast as date (result will be...

  • RE: coalesce and nullif

    Thanks, Oleg, for the explanation of the difference between COALESCE and ISNULL. I was about to add it myself, since it is lacking in the question, but you beat me...

  • RE: T-SQL Logic

    I hope it is not considered cheating that I did run SELECT database_id, name FROM sys.databases ORDER BY 1; before answering. I don't thik there is any need for me...

  • RE: HAVING

    Paul White NZ (6/21/2010)


    Rick Lang (6/21/2010)


    Perhaps a different version of the question where the answer would be different with the Having clause vs just the where clause might help to...

  • RE: insert into temp table

    Lisa Phillip (6/21/2010)


    If the column 1 in the table HAD a null value for one of the rows, how could the resulting table POSSIBLY end up being defined as NOT...

Viewing 15 posts - 2,761 through 2,775 (of 3,348 total)