Check out our New Aspin Website in Beta:
New Name, New Features, Same People!
 ASP Database Servers - ASP tutorial, script, programming, code

Aspin.com
  
 Navigator >
Resource Home: Tutorials & Code Snips: Database: Database Servers
   You are 1 of 181 Active Visitors.
Menu >
Hot Deals  |  My QuickList  |  Newsletter  |  What's Cool  |  What's Hot  |  What's New  |  Login

 Sponsor

  Database Servers     Add to QuickList   

How to Get Identity of New Record Site: Dotnetindex.com
  Hits Today: 2  Total: 2520
Updated: 4/5/2004
Reviews: 0  Rating:  
 Read Reviews  |  Report Error  |  Add To QuickList
Sometimes you need the learn new record number while your are adding a new record. Following example adds a new records to a table and gets the the autonumber or identity of that records.   Author: Dotnetindex.com   Code: ASP 3.0 & VBScript

@@IDENTITY crisis (SQL Server) Site:
  Hits Today: 1  Total: 6269
Updated: 8/29/1999
Reviews: 0  Rating:  
 Read Reviews  |  Report Error  |  Add To QuickList
Active Server Corner has published "@@IDENTITY Crisis," an article that takes a look at what identity columns are and things you should know about them.   Author: Manohar Kamath   Code: ASP 2.0 & VBScript

Getting Identity Site: Chris Garrett's RealWorldASP
  Hits Today: 1  Total: 3644
Updated: 2/18/2002
Reviews: 0  Rating:  
 Read Reviews  |  Report Error  |  Add To QuickList
If you are using a stored procedure you can return the value of the Identity field (Autonumber for access users) for the record just added using '@@identity' but how do you do it outside of a stored procedure.   Author: Chris Garrett   Code: ASP 3.0 & VBScript
 Sponsor



Icon Key >   - Within 4 Days    - Within 8 Days    - Within 12 Days  
  - Showcase - Cool Stuff  - Directory Shortcut 

Submit or Update a Listing  |  Link to Us Advertise  |  Contact Us  |  Site Help

ASP Database Servers - ASP tutorial, script, programming, code Home  |  Link to Us  |  Advertise With Us
About Us  |  Contact Us  |  Site Help 		       

© 1999-2008 InfoGenius Inc., All rights reserved  |  Terms of Use