• john.arnott (2/11/2010)


    <rant on> I can't imagine that 85% of respondants actualy knew the result of the SELECT

    where the condition is false would not be assigned to the variable. </rant>

    What difference does it make? At the end of the day, answering a good QotD correctly only gives you two things:

    1. A better understanding of SQL / SQL Server.

    2. An increase to your SSC points.

    The better understanding of SQL / SQL Server comes when you either think the question through or research it out. It does not come from simply copying and pasting into SSMS -- that only tells you what happens, not how or why.

    The SSC points are cute, and can be a fun little game to play with your fellow SSCers, but they have no intrinsic value beyond this site.

    So, those people who just do the copy-and-paste are actually cheating themselves out of better knowledge for a few measley points. Let them.

    For the record, I got this one correct because I've seen this before.