Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
To NULL or not to NULL
Message
De
20/01/2005 21:16:52
 
 
À
20/01/2005 19:21:59
Stuart Ramsey
Medical Business Systems
East Gosford, Australie
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Divers
Thread ID:
00977538
Message ID:
00979161
Vues:
21
Hi, Stuart

I didn't check it neither, but you may be right. It depends on implementation and I'm pretty sure that various backends treat NULLs differently. I did not check all the variations of all agregate functions :)

Thank you for letting me know.
Grig.

>Hi
>Was having a read on this subject, and found that COUNT is only NULL aware for a specific column and thus SELECT ALL with COUNT is not, NULL aware. Havent tested this yet, but thought i would drop you a line!
>Regards
>Stuart Ramsey
Grigore Dolghin
Class Software.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform