Charlotte Foust
cfoust at infostatsystems.com
Mon May 9 18:45:18 CDT 2005
I think the key word there is "experts", Stuart. Unfortunately, real world databases are usually used and commissioned by non-experts and their requirements may be at variance with good practice. Getting paid may involve compromise. ;-> Charlotte Foust -----Original Message----- From: Stuart McLachlan [mailto:stuart at lexacorp.com.pg] Sent: Monday, May 09, 2005 4:35 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] ANSI null compliance On 9 May 2005 at 19:22, Arthur Fuller wrote: > > With Codd, Date, Pascal and Celko, to name just a few experts in the > field, I think there is a problem with nullable columns. In general they > indicate that the database model has not been sufficiently considered. > ?????????? Codd Rule 3 Null values (distinct from the empty character string or a string of blank characters and distinct from zero or any other number) are supported for representing missing information and inapplicable information in a systematic way, independent of data type. -- Stuart _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com