Web Programming

Only members of this group can post notes and use other group resources. Join now to get access to all group resources!
Log in or register to join this group

Classic ASP Get the new SQL ID record  Viewed 17282 time(s), 2 post(s)., 1/8/2014 3:28:11 AM - by Suzan

Suzan
Suzan 1/8/2014 3:28:11 AM

I am using ASP and MS SQL 2008 Express. How can I get back the autogenerated ID for a new record I just inserted?

This content has not been rated yet. 
118 Reputation 12 Total posts
1
Sam
Sam 1/9/2014 4:03:07 AM

SCOPE_IDENTITY is what you need

This content has not been rated yet. 
233 Reputation 37 Total posts
2