Last Record Added

Results 1 to 2 of 2

Thread: Last Record Added

  1. #1
    Join Date
    Dec 1969

    Default Last Record Added

    I saw in the ASPFAQ's how you retrieve the AutoNumber field of the record just added for an Access DB but that does not seem to work with SQL Server. Can anyone tell me how to do the same thing with a SQL identity columnn? Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: Last Record Added

    I usually do something like...<BR><BR>SELECT MAX([autonumberfield]) + 1 AS NewID<BR>FROM [tblname]<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