Auto ID in SQL Server....

[ksutton]

I am inserting into a SQL table with "INSERT INTO...." and the table has an auto-increment ID field.

Is there any way that I can return that value within the INSERT call to the DB? Or do i have to do my INSERT and then a SELECT?

Thanks,
Kevin

[JHausmann]

Originally posted by ksutton
I am inserting into a SQL table with "INSERT INTO...." and the table has an auto-increment ID field.

Is there any way that I can return that value within the INSERT call to the DB? Or do i have to do my INSERT and then a SELECT?

Thanks,
Kevin

You could create a stored procedure...