SQL: NULL Support
Have you ever run across the suggestion that you should always use NOT NULL when creating a database table? What is NULL, anyway? Why would you want to use it? What are the advantages to using NULL? How does NULL figure in to LEFT OUTER joins?
Rudy answers these questions with plenty of examples in this article about NULL. The advantage to using NULL is described in the context of designing database tables where a column's value can be unknown or not appropriate. NULL is also discussed in the use of aggregate functions. Finally, an illustration of NULL in LEFT OUTER joins is provided.
Should you use NULL? This article answers the question positively.
Rudy Limeback is an independent consultant with over 20 years of SQL experience using DB2, SQL Server, Access, Oracle, and MySQL. Rudy is also a Web developer, Technical Editor at Digital Web, one of the original evolt.org admins, with his own Web site since 1996. More information at r937.com. Rudy lives in Toronto, Canada, where the weather allows you to play frisbee golf all year long.