I do not do personal attacks but I don't mind pointing out absurdities.

[Snipped idiocracies]

Who else than an ignorant would write such absurdities?...

//I find your conflicting statements "absurd". On the...

<>

I have proved my points one by one. When somebody stands in public and vehiculates misconceptions and fallacies, he should be willing to take the beating or back up his...

Now, because I have pointed out for the readers the incoherence of the article -->I am the *bad guy*.

You will soon realize that I have not so far...

//* why does SUM behave this way with NULLs ? To be consistent with the interpretation of NULL as "unknown value" I would want SUM to return NULL as soon...

//Thanks Tim. As soon as I saw Cimode's reference to "database fundamental theory" combined with his poorly designed examples that don't even run, which only provided proof of what...

//Speaking of "no clue"...

select(field1) + sum(field2) from #table1

... will yield ...

Server: Msg 8118, Level 16, State 1, Line 1

Column '#table1.field1' is invalid in the select list because it is not...

I'll attempt to address your concerns one at a time here:

People do not confuse, people are either ignorant or misled by ignorants. That the case of the person who wrote...

//Cimode

I take great exception to the tone you have used in your responses. This is a forum for people to share ideas and experiences and you calling us ignorant...

//For quite some time we have been using a particular syntax which has worked quite well for us in determining NULL matches.

In our where clause we would use...

Where ISNULL(column,'') ...

//I agree that working with NULLs can cause problems but to simply say "never use them" is irresponsible. Just like everything else, use them properly and know your system...

//There's a workaround on this one... but it comes with a cost ://

You call a workaround. I call it a hack.

//Or are you advocating that for text "no value" should always be a blank, not a null? I'd like a detailed answer on the overall impact that has, especially...

//One thing that frustrates me about how SQL Server handles NULL within unqiue constraints is that it does only allow one NULL value (as the article does a nice job...

//Can you take 5 minutes of your time and write an article that will "correct" the situation and share it with the world... you will also be paid for sending...

//Thanks for sharing.it is very common one ,but peple even confuses.

it might clear the confusion of those//

People do not confuse, people are either ignorant or misled by ignorants. That...