Re: Null vs. nothing



wjdennis@xxxxxxx wrote in
news:1156966064.694779.323840@xxxxxxxxxxxxxxxxxxxxxxxxxxxx:

I'm looking at a table with two date/time columns in it. One
colulmn has its Default Value set to Null, the other has nothing
in the Default Value entry. What is the difference between these
two Default Values?

There is no difference if Allow zero-length string is off. If it's
on, I don't think there's any difference, either, but I can't think
of a good reason to ever set it on, so I could be wrong.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.



Relevant Pages

  • Re: How to get rid of database name from Open list
    ... Uncheck it, ... Is it not stored in the Registry, so you could just remove the entry ... usenet at dfenton dot com http://www.dfenton.com/DFA/ ...
    (microsoft.public.access.gettingstarted)
  • Re: How to concatenate words
    ... Left fixing the last entry as exercise for you. ... Good luck ... Since you might be new to usenet, ...
    (comp.unix.shell)
  • Re: Why Pilots of America rocks...
    ... again in virtually every newsgroup on USENET, ... That's because your entry to this group precipitated the worst ... troll invasion ever seen here. ... Who would move to Iowa City by ...
    (rec.aviation.piloting)
  • Re: Beginning, Middle and End
    ... usenet, so why *woulnd't* people want to find out more? ... As further evidence, I note that Dorothy has a Wikipedia ... *Someone* was sufficiently interested to create the entry. ...
    (rec.arts.sf.composition)
  • Re: Beginning, Middle and End
    ... usenet, so why *woulnd't* people want to find out more? ... As further evidence, I note that Dorothy has a Wikipedia ... *Someone* was sufficiently interested to create the entry. ...
    (rec.arts.sf.composition)