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]

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]

Scope_Identity

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

Jeff

Thanks Jeff!

Jim