[thelist] Insert Nothing

Steve Lewis nepolon at worlddomination.net
Mon Sep 27 13:56:45 CDT 2004

Rob Smith wrote:

> I want to insert nothing into an SQL Server table. 
> INSERT INTO myTable () VALUES ()
> My table structure is this:
> caid		int		4		not null
> auto_increment
> timevisited	datetime	8		not null	(getdate())
> How can I achieve this?

You cannot.  Either allow null, or use a special value (perhaps a 
datetime that is so far in the past that you know it is bogus).  The 
later is a weaker solution.  This looks to me to be a good case for 
allowing and using null on the timevisited field.

Steve Lewis

More information about the thelist mailing list