Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Returning the ID of a newly inserted record

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-02-16 : 08:17:52
Aecio writes "Hello!
I once read an article that described how to return the key (id) after inserting a new record. I cannot find that article any more so I decided to write asking how to do this.

I have an insert query inserting a row into a table with an identy field. This field will generate the identity (id) number automatically once the record is inserted. How can I get this number after this insert so as to use it in my code?

Thank you for your help!"
   

- Advertisement -