john.arnott (2/11/2010)
<rant on> I can't imagine that 85% of respondants actualy knew the result of the SELECTwhere 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.