Alex

Recent Blog Comments By Alex

• Why NULL Values Should Not Be Used in a Database Unless Required

  Posted on Aug 14, 2009 at 11:09 AM

  Your question is rather off-topic... however, you can't set the default value in the same ALTER statement as you create the column, as it's actually a constraint and not just a property of the column. Here is what you'd want to do after creating the column: ALTER TABLE addresses ADD CONSTRAINT DF_a... read more »

• Why NULL Values Should Not Be Used in a Database Unless Required

  Posted on Aug 3, 2007 at 11:07 AM

  To Ian, yes I agree that's pretty much the only circumstance that calls for using an empty string. However, those sorts of questions should generally be answered by the time an application goes production. ("Generally" being the key word there.) To Ben, I'm not very familiar with Cold Fusion, but i... read more »

• Why NULL Values Should Not Be Used in a Database Unless Required

  Posted on Aug 2, 2007 at 6:59 PM

  Null means nothing. It's empty. Previous comments have tried to pin it down to a reason why it's empty, this is absurd. There are no conclusions you can draw from a null except that no information was provided, you can't say it wasn't provided because it wasn't known, or it wasn't provided because i... read more »