[dba-SQLServer] NULLs

Dan Waters dwaters at usinternet.com
Mon Mar 16 12:50:52 CDT 2009


Hi Gustav - I know I'm contradicting someone else!  But if you find that I'm
contradicting myself - please contradict me right back!  ;-)

Dan

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Gustav
Brock
Sent: Monday, March 16, 2009 12:43 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [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.



_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com





More information about the dba-SQLServer mailing list