[thelist] Free Tip about SQL

[Plunkett, Matt]

My syntax was a lil off...corrected below.

-----Original Message-----
From: Plunkett, Matt 

>>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? ..."

In PL/SQL, you can just do: 

INSERT INTO tablename (..) VALUES (...) RETURNING idcol INTO varname.  

I would imagine most languages have a built in technique for doing this.