I'm using Execute(SQL Statement) in ASP and when I 'INSERT INTO' a table, a record, the PRimary Key (recordID) is autonumbered. How do I find out what that unique value of the last inserted record is?
you will find info about @@IDENTITY
but there is a specific FAQ for this issue.<BR><BR>
a link to the FAQ or somewhere, where I can find the answer would be helpful!
and all other pages here, ASPFAQS. You will find your question in the database section.