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.