last inserted raw (identity)

 Is there an environment variable that returns the
primary key of the last inserted row. This is usefull
if you insert a rwo and need the primary key to insert
it into another table as a foreign key.

 In MS-SQL that is equivalent to @@identity variable:
 insert into organization ('org name', ....)
 insert into contact (@@identity, 'contact name'
.....)
 Here Identity is the organization's ID that is needed
as a foreign key in contact table.

 Cheers.


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com