[dba-SQLServer] NULLs

Hi Dan

I think you - or someone else? - are contradicting yourself or someone else(?) - at least "me am totalyful confusticated" now!

/gustav

>>> dwaters at usinternet.com 16-03-2009 18:37 >>>
Well - that wasn't my argument. I think Nulls are fine and appropriate.  

What I would not do myself is allow a FK to be Null.  To me that would
indicate a poor table/app design.

Dan

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com 
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Susan
Harkins
Sent: Monday, March 16, 2009 12:08 PM
To: Discussion concerning MS SQL Server
Subject: Re: [dba-SQLServer] NULLs

But you still have a null, and wasn't the argument against nulls, period?

See, I'm having a real problem with the idea that null isn't valid and 
shouldn't be allowed at all.

Susan H.


> It's Null - but your data validation must ensure that one of the two 
> fields
> is correctly filled in.  I see data validation as not applying to just
> single fields, but also applying to combinations of fields.