469,946 Members | 1,750 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,946 developers. It's quick & easy.

Question about getting the latest identity field in a specific table

Dear All,

Suppose in the program a record is added to a table whose
primary key is a identity field. If I really want to get the lastest
value for that field after the insertion, is it the best way to use
IDENT_CURRENT() to obtain this value?

Thanks for your kind attention

Yours faithfully,
Benny
Jul 20 '05 #1
2 2466
I would rather use SCOPE_IDENTITY() or @@IDENTITY depending on the
requirements. SQL Server Books Online states that, IDENT_CURRENT is similar
to the 2000 identity functions SCOPE_IDENTITY and @@IDENTITY. All three
functions return last-generated identity values. However, the scope and
session on which 'last' is defined in each of these functions differ.

- IDENT_CURRENT returns the last identity value generated for a specific
table in any session and any scope.
- @@IDENTITY returns the last identity value generated for any table in the
current session, across all scopes.
- SCOPE_IDENTITY returns the last identity value generated for any table in
the current session and the current scope.

--
- Anith
( Please reply to newsgroups only )
Jul 20 '05 #2
Anith Sen (an***@bizdatasolutions.com) writes:
- IDENT_CURRENT returns the last identity value generated for a specific
table in any session and any scope.


One important thing to clarify here is that IDENT_CURRENT() can be affected
by insertions by other processes, where as scope_identity and @@identity
cannot.

Thus, ident_current() is rarely the function you should call in application
code.

--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

18 posts views Thread by Guinness Mann | last post: by
4 posts views Thread by cyansoft | last post: by
3 posts views Thread by Tcs | last post: by
1 post views Thread by Steve Leferve | last post: by
2 posts views Thread by Wayne Wengert | last post: by
3 posts views Thread by reageer | last post: by
9 posts views Thread by David Eades | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.