that will only get the records where the value is null. and only if you passa zero as the param value.

I didnt notice if anyone mentioned this, but I've run into some very odd things when attempting to pass NULL as a parameter value though a web service back to...

that was a real thinker, got it wrong, but learned someth9ing new. thanks!

I got it right, and I think that the question was pretty obviously referring to CPU resources on access of the field. A calculated field is not going to be...

actually:

Select [anything].some_data from [where] [anything]

Hugo Kornelis (7/13/2010)

---

I got it wrong too. I was looking at the logic of the query and the subquery, not at all the fine punctuation details.

Learned nothing from this question....

funny, teach me to read the question in the email, then read it again when I hit the site... they could very well be different questions... an annoying test in...

Hugo Kornelis (6/23/2010)

---

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

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

there are no negative database ids 🙂

and there is no 0

thus 1 is the answer to the most obfuscated question ever!

Hugo Kornelis (6/21/2010)

---

Good question, but the explanation is lacking. I think that the +=, -=, etc operators are generally even better known than the bitwise operators used here (even if...

In 2008 creating temp tables on the fly has been severely restricted. creating more than a list of id's (or any other single column with first ordinal position) in this...

john_wong_ca (6/9/2010)

---

That's a good idea. This will work for most of cases but not for replication. If a table is published in a merge publication, while replication agent is modifying...

ziangij (6/8/2010)

---

thanks, great question... got it wrong though 🙁

A user-defined stored procedure that has the same name as a system stored procedure and is either nonqualified or is in the...

Nailed it, because I assumed that "person" was not me. If I were "person" the answer would have been 5.