I do agree the question would have been more instructive without the "gotcha" but I can't argue about the answer.

EDIT: And after reading Thomas Abraham's response, I take back my...

I'm hoping by this afternoon I will have read the explanation enough times to understand it, because I sure as heck don't at this hour of the morning!

ron

Silly me, assuming the blatantly obvious answer couldn't possibly be correct.

ron

That was an excellent question, and not at all a "trick question"... very nice!

ron

Carlo Romagnano (8/3/2011)

---

EXISTS check if subquery returns ROWS and does not execute EXPRESSION or read column value. So, in this case divide by zero is never executed, but ONE ROW...

In my particular case, it was found in some Access data...

I noticed that too, and it inspired me to search my code for any varchars and change them to nvarchars,...

While you guys argue over the correct answer, I'm going to spend the morning learning what "re-entrant" means.

ron

Because aggregate functions ignore NULLs, right?

Good question today, thanks....

I may not have learned anything directly from the question; but on the plus side, in researching the question I did learn all about sexy prime triplets.

>>>No, I'm not kidding!<<<

ron

The nearly 40% of respondents who got it wrong learned something today. That alone seems valuable enough to me,...

I haven't had great experiences with telecommuting. I know for sure it's not for me; I need that clear separation between work time and home time or else I'm...

I understood the question, and I thought it was a good one. I had honestly never considered whether or not the INSERTED table could be updated. I thought...

Hugo Kornelis (1/4/2011)

---

I replied wrong - I saw the rollback after the truncate, assumed the question intended to test my understanding that a truncate can be rolled back, and then...

Well that's what I get for second-guessing myself. It seemed like such an easy question, the obvious answer couldn't possibly have been right. Guess that'll teach me!

Ron