Article Link.

In SQL, I see how to use this @@identity, but is there any way this variable is attainable through an ODBC connection, like when using ASP? It'd be wonderful to just touch this variable, instead of having to close and open another recordset to find out the ID of what I just inserted.

what if insert statement causes a trigger to fire, which in turns inserts another record into a different table.
What will @@identity return?
From my experience it will return id from the last table inserted.

This approach is fine if there are no triggers on the table which insert any data.

Mikhail
mikeg@vuepoint.com