identity columns

Results 1 to 3 of 3

Thread: identity columns

  1. #1
    Join Date
    Dec 1969

    Default identity columns

    having problems displaying database details saved to a database using ASP and SQL (SQL Server 2000)<BR>i run an insert procedure and return the @@identity column.<BR>i can see this by using a response.write.<BR>however, when i try and use it in a select statement i get an eof or bof error.<BR>i tried using the .nextrecordset method on the execute statement.<BR>if i copy the @@identity variable and use it with sql then i get the record set but for some reason asp can not see it immediately after the insert.

  2. #2
    Join Date
    Dec 1969

    Default code please <eop>


  3. #3
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: identity columns

    @@identity will return the last identity value generated AFTER an insert.<BR><BR>If there was no insert or select into or any other statement where a row was actually inserted then the @@identity will NOT have a value.<BR><BR>I would suggest you actually go to and look up and R&D @@identity<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