How to retrieve Column Identity after Insert?

[JohnBeals]

On SQL 7, using a Query Insert:
I need to get the Column Identifier of the new record after an Insert. Does the Insert return any values?

My concern is, that if I get the last ID and then assume the next ID is from the record I inserted, another user could possibly do an insert between my querying the last ID and inserting the new record.

Your assistance is appreciated!
JB

 

[JohnDTampaBay]

You should be able to capture the value of @@IDENTITY after the INSERT statement to access the id value inserted in table.
--Angel
-----------------------------------
SELECT * FROM users WHERE clue > 0
0 row(s) selected

 

[r937]

@@IDENTITY

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp

rudy

http://rudy.ca/

 

[JohnBeals]

That's it!

Thanks!!!
JB