|
Posted by David Portas on 09/20/05 00:21
SELECT IDENT_CURRENT('table_name') ;
--
David Portas
SQL Server MVP
--
"trint" <trinity.smith@gmail.com> wrote in message
news:1127164340.720014.70160@g14g2000cwa.googlegroups.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
>
Navigation:
[Reply to this message]
|