Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Return identity value from newly inserted record
Message
From
04/10/2001 18:08:26
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Return identity value from newly inserted record
Miscellaneous
Thread ID:
00564540
Message ID:
00564540
Views:
50
Is there an easy way to return a key value generated from a field incremented with identity right after an insert of a single record?
I've ben using " Select max(identity value) from table" right after an insert and wory about possible updates happening before I can get max() retuned.

Thanks
Jeff
Next
Reply
Map
View

Click here to load this message in the networking platform