A Better Way to Retrieve the ID of the Last Inserted Record

This tip is a follow-up to the tip Retrieving the ID of the Last Inserted Record. In that tip, the SELECT command is longer than it needs to be. Here’s the original:

SELECT job_id FROM jobs WHERE job_id = @@IDENTITY

To simplify the code, I suggest simply writing:


You get the same result either way, but the second version avoids a search of the jobs table.

Editor’s Note: Beware of problems that can occur when using @@IDENTITY. Depending on your situation, you should consider using either the SCOPE_IDENTITY() or IDENT_CURRENT() method instead. For more information see this link.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin


Recent Articles: