OK, so why did my server return NULL ?

Kenneth Spencer

"In SQL Server 2005, which of these data types have the highest and lowest precedence respectively?"

Yet another example of an abysmally worded question.

This question MUST have two answers, but we...

This question is very badly implemented. I knew it couldn't create a database on my system because it made too many assumptions:

1. Can I write to the root directory of...

Come on, don't be such a twerp! There is no such role as "db_ssisitduser". There is a role "db_ssisltduser" but if you meant that one then shame...

Sorry question-master, but I disagree.

A "log" file is not the same as a database file. A "log" file is a "log" file, and what it holds may be "data",...

Thanks Steve, that is indeed very kind of you !!

And I won't hold it against you just because you are from the US !!!

Ken.

Objection!!

Value1 is indeed LESS THAN value1, no matter how many times value1 appears in the table.

Therefore I claim my points.

AND don't claim that you didn't mention case sensitivity, because we...

Mike:

Yes,...

That is a good question.

Personally, when I design database schemas where some of the data has to be date-ranged (and lots of data items in most data models must...

Sorry, but because I couldn't read your post while writing my reply, I forgot to add my third point:

3. Zero ( 0 ) is most definitely NOT the same as...

Sorry not to be repentant, but:

1. NULL is indeed "not [yet] assigned". That is the case in any database column which has no value, but which has the capacity to...

I agree with the main thrusts of this article. However, I do not consider the NULL to be "missing data". The NULL must simply be considered as either "no value",...

Points taken, absolutely Shaun.

However, NULLs cannot be excluded from the results of queries. Suppose for instance, looking again at my example, we have some kind of accounting database, with...

I prefer to use the term "NULL propogation" for this kind of behaviour. It is a little like multiplication of any non-zero operand by zero giving zero, except that NULL...