SQL Insert

Results 1 to 2 of 2

Thread: SQL Insert

  1. #1
    Corin Guest

    Default SQL Insert

    if I just executed a SQL statement and my primary key is an autonumber is there a quick way to get the autonumber assigned to the row I just inserted. I don&#039t want to do another recordset call. Is there a way for the SQL INSERT to return that value.<BR><BR>Thanks in Advance

  2. #2
    Join Date
    Dec 1969

    Default ASPFAQs (top of this page) #79

    http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=79<BR><BR>If you are using Access, the scheme shown really is the best way.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts