SQL - Inserting a blank row

Karl · 19 Dec 2006 at 15:21

Hello!

I'm working in SQL Server 2000, and I've got a single column in my table which has an identity (An auto-incrementing primary key).

I want to use a SQL insert statement that just inserts a new record.

Something like:

Code:

Insert INTO Session () VALUES ()

The reason I want to do this is to get a guaranteed and recorded unique session ID that doesn't rely on ASP's session object, and can be permanent, or at least as long as the cookie lasts.

Any thoughts?

Cheers for your ideas in advance.

Karl.

tonyyeb · 19 Dec 2006 at 15:28

How about:

Code:

Insert INTO Session (2) VALUES ('')

This should insert nothing into column 2.

Note: it is 2 x apostaphies in the VALUES section

Karl · 19 Dec 2006 at 15:35

A good guess, but unfortunately I don't have a second column to deal with.

The table consists of only the primary key, as no other information to go in this table is pertinent, and it's literally just a way of generating a 100% unique number.

tonyyeb · 19 Dec 2006 at 15:37

How about creating a second column?

I cant see how it could be done otherwise? Maybe use ADODB.Add? Instead of SQL INSERT?

Karl · 19 Dec 2006 at 15:43

That might be an option, I'll look into that.

It'd be tidier if I didn't have the 2nd column, but if I have to I will.

Thanks for your input mate.

Karl · 19 Dec 2006 at 15:48

I don't know if you can use adodb.add in an ASP sense. I've had a quick look on google, but it returns less than 5 results with some omitted. I guess I'll add an extra column!

tonyyeb · 19 Dec 2006 at 15:51

Have a look here:

http://stardeveloper.com/articles/display.html?article=2000032601&page=1

My syntax was not correct. Look down the page to the heading 'Via Recordset Object'

Using rs.addnew