By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,693 Members | 1,646 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,693 IT Pros & Developers. It's quick & easy.

Identity...I need to get the last (or highest number in Identity column)...

P: n/a
Ok,
I just need to know how to get the last record inserted by the highest
IDENTITY number. Even if the computer was rebooted and it was two
weeks ago. (Does not have to do with the session).
Any help is appreciated.
Thanks,
Trint

Sep 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
SELECT IDENT_CURRENT('table_name') ;

--
David Portas
SQL Server MVP
--
"trint" <tr***********@gmail.com> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com...
Ok,
I just need to know how to get the last record inserted by the highest
IDENTITY number. Even if the computer was rebooted and it was two
weeks ago. (Does not have to do with the session).
Any help is appreciated.
Thanks,
Trint

Sep 19 '05 #2

P: n/a
Thank you for your quick response, David.
Trint

..Net programmer
tr***********@gmail.com

*** Sent via Developersdex http://www.developersdex.com ***
Sep 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.