Nulls debate

Hi!
What's your opinion about whether null columns should ever allow nulls (or not)?
Thanks in advance for your comments.
We don't have to hash this out again, do we?
http://groups.google.com/groups?hl=e...A*sqls erver*
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Francisco" <anonymous@.discussions.microsoft.com> wrote in message
news:A2A108C8-BD9F-4B70-9921-A306FB506B5F@.microsoft.com...
> Hi!
> What's your opinion about whether null columns should ever allow nulls (or
not)?
> Thanks in advance for your comments.
>
|||If your business rules determine data for a column may or may not be present
then nulls should be allowed in your table design. Now on the flip side if
you business rules say there should always be data for a column, then you
should NEVER design your table to allow nulls since this violates your
business rule.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Francisco" <anonymous@.discussions.microsoft.com> wrote in message
news:A2A108C8-BD9F-4B70-9921-A306FB506B5F@.microsoft.com...
> Hi!
> What's your opinion about whether null columns should ever allow nulls (or
not)?
> Thanks in advance for your comments.
>
|||Sorry Aaron, I didn′t mean to offend you.
Sorry my ignorance. Perhaps I make a mistake to express my doubt.
|||Why do you think you offended me?
It's just a very common debate, and the google threads should provide you
with all the information that could possibly be offered again...
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/