Dan Waters
dwaters at usinternet.com
Mon Mar 16 12:37:30 CDT 2009
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