Kris
Member since Sep 3, 2014
- Profile: /members/12244-kris.htm
- URL: http://www.essentialsql.com
- Comments: 1
Recent Blog Comments By Kris
-
Why NULL Values Should Not Be Used in a Database Unless Required
Posted on Sep 3, 2014 at 10:43 PM
Hi, Of course you could argue the same about blanks... Don't allow them! Convert them to NULLS... Then you can easily write the following SQL... SELECT COUNT( * ) FROM test t WHERE t.name IS NULL And not worry about blanks...... read more »