Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
To NULL or not to NULL
Message
From
20/01/2005 21:16:52
 
 
To
20/01/2005 19:21:59
Stuart Ramsey
Medical Business Systems
East Gosford, Australia
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
00977538
Message ID:
00979161
Views:
22
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform