Results 1 to 2 of 2

Thread: Bob

  1. #1
    Rob Guest

    Default Bob

    How do I get the record number of a just added record, using an sqlserver database table?

  2. #2
    Join Date
    Dec 1969

    Default RE: Bob

    Depends.<BR><BR>what type fo datatype are you using.<BR><BR>you could use the criteria that you used to insert the record.<BR>if its an identity column, you could select the identity, or for information on doing that in 1 sql statement. <BR><BR>you could use MaX,Top all kinds of stuff.<BR><BR>might want to clarify, or go with one of those solutions, but let it be know, unless you lock the table, you are not guaranteed you will get your record back. <BR><BR>remember, nothing is guaranteed.

Posting Permissions

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