Insert with Autoid

[wavve]

Hi,
I have a table called note and it has an ID column in it. I'd like to be able to add notes in the text column and then have hte ID column automatically generate a unique id. I'm using SQL Server 7.0 with ultradev 4. Does anyone know how I can do this? I'm currently able to update the database fine but I'd like a unique id generated.

Thanks

 

[mlawson]

Hi,

I'm not sure if you have been told this, but you could use the autonumber facility to automatically generate an incremental ID value thus bypassing the need for any fancy-shmancy database query stuff.

M "There are 3 kinds of people; those that can count and those that can't"