[thelist] Insert Nothing

[Steve Lewis]

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