And what about not mentioned option "empty value". For numerics it is clear, but for strings, it's dangerous to mix with empty string.

NULL is unassigned value - no value at...

Sorry: NULL IS NULL.

Paul White NZ (4/7/2010)

---

honza.mf (4/7/2010)

---

Be aware! This setting is per connection, not per server. And SP keep the setting of the connection they are created in. Remarked by a...

Only when you need negative comparisons.

A <> 1 doesn't return rows where A is null with ANSI NULLS...

Be aware! This setting is per connection,...

Steve Jones - Editor (3/19/2010)

---

A great discussion, and I'll weigh in here on this question and topic. First, I disagree with John in that I think I bear some responsibility...

petertrast (3/19/2010)

---

Well said. If anyone besides the submitter is responsible, it would be BOL (Microsoft indirectly) and the forum moderator (sorry Steve :-D). The person answering can only bring value...

As I'm awaking: It's a pitty SSC has only QotD with one correct answer (radios) or more correct questions (checks). This one is candidate for order (first three). It could...

0/69 now.

I think the "correct" answer is worth 100 or maybe 1000 points 😛

The responsibility of submitter is clear. But the readers? Sorry, they are responsible for the quality of...

Lynn Pettis (3/3/2010)

But back to the QotD, here, you sometimes just have to make an assumption using common sense. In this case, it makes sense that the table tblUsers...

Lynn Pettis (3/3/2010)

And I'm sorry if you don't like assumptions, do you work with users that always tell you everything you need need the first time? Must be nice,...

Lynn Pettis (3/3/2010)

---

Second, it doesn't matter how many rows are in the table tblUsers (unless it only contained one row, but everyone so far has assumed more than one), this...

Toreador (3/3/2010)

---

Well it seems a reasonable assumption that tblUsers exists, and is a table.

You then have to guess about data volumes...

WTF is tblUsers?

It can be a table or a view or nothing.

If it is anything defined (table or view) it can be empty (0 rows returned), it can contain just...

Best time (for deployment too) is when boss is out.

My boss goes to holidays tommorow, our director is in spa. Life is beautiful.