[thelist] Free Tip about SQL

Joshua Olson joshua at waetech.com
Fri Jul 18 11:30:35 CDT 2003

----- Original Message ----- 
From: "Rob Smith" <rob.smith at THERMON.com>
Sent: Friday, July 18, 2003 11:53 AM

> A colleague of mine came up to me and asked:
> "Is there a way, in a SQL statement, to return the auto generated ID of a
> record when it's created by an insert values query? ..."
> I answered:
> "Add another column in your table for a timestamp varchar(24) variable.
> Store that number as a variable. Then at your leisure call for a row that
> contains your newly added timestamp variable and you'll have the new ID.


In MS SQL Server the variable @@identity contains the id of the last auto
generated ID.  Other databases usually have something equivalent.

Also, a GUID may provide you an alternative to using a timestamp.

Good luck,

Joshua Olson
Web Application Engineer
WAE Tech Inc.

More information about the thelist mailing list