[thelist] returning the row id after an insert (MS SQL 7)

[Chris Blessing]

This is probably a common question but a search didn't provide me with much
so...

What I'm doing now is inserting new rows into my table and then selecting
the row id with a separate sql statement based on the data inserted in the
prior sql statement.  Isn't there a way to do this in one statement rather
than 2?  Any help is much appreciated.

Chris Blessing
webguy at mail.rit.edu
http://www.330i.net