[thelist] Insert Nothing

[Joshua Olson]

> -----Original Message-----
> From: Rob Smith
> Sent: Monday, September 27, 2004 2:10 PM
>
> Hi list,
>
> 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())

Rob,

I'm not sure that you can insert an empty, but you could always:

INSERT INTO myTable(timevisited) VALUES (GetDate())

On a side note, you may want to consider dumping this information to a text
file and then performing a bulk import--if you don't need to have this data
real-time.  Doing it this way will improve performance in situations where
you have a large number of visitors.

<><><><><><><><><><>
Joshua Olson
Web Application Engineer
WAE Tech Inc.
http://www.waetech.com/service_areas/
706.210.0168