Auto ID in SQL Server....

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

Quote:

---

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...