sql command to get ID (primary key number) of last record inserted

[Jim in Arizona]

I forgot what the SQL command was to return the key of the last inserted
record. Does anyone happen to know what it is?

Thanks,

Jim

--

[Jeff Dillon]

Re: sql command to get ID (primary key number) of last record inserted

"Jim in Arizona" <tiltowait@hotm ail.comwrote in message
news:OkZ2vywMJH A.1304@TK2MSFTN GP02.phx.gbl...

>I forgot what the SQL command was to return the key of the last inserted
>record. Does anyone happen to know what it is?

Scope_Identity

http://msdn.microsoft.com/en-us/library/ms190315.aspx

Jeff

[Jim in Arizona]

[RESOLVED] Re: sql command to get ID (primary key number) of last record inserted

Scope_Identity

>
http://msdn.microsoft.com/en-us/library/ms190315.aspx
>
Jeff

Thanks Jeff!

Jim