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:
SELECT @@IDENTITY
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. |
If you have a hot tip and we publish it, we'll pay you. However, due to accounting overhead we no longer pay $10 for a single tip submission. You must accumulate 10 acceptable tips to receive payment. Be sure to include a clear explanation of what the technique does and why it's useful. If it includes code, limit it to 20 lines if possible.
Submit your tip here.
Digg
del.icio.us
Newvine
furl
StumbleUpon
BlinkList
Newsvine
Magnolia
Facebook
Tailrank
Slashdot
Technorati
Google Bookmarks
Yahoo Favorites
Windows Live
Ask
