Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Advanced
Oct 26, 2009

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:

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.


Martin Vitek
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap