From: David Naseby <david.naseby@...>
Date: 2004-07-29T08:04:50+09:00
Subject: Re: Stupid ODBC!

> From: Nathaniel Talbott [mailto:nathaniel@talbott.ws]
>
> On Jul 28, 2004, at 18:38, Lennon Day-Reynolds wrote:
>
> > The problem is that it appears that SQL Server (and most like the Jet
> > engine, too) has *no* way to get said information -- if you want a
> > 'rowid', it has to be in your table schema.
>
> Here's the code I used for SQL Server:
>
>    SELECT @@identity
>
> I forget all the forms of that, and the exact scope it operates in, but
> it should at least get you started.

I believe its recommended to use

	SELECT scope_identity()

on Sql Server. Ref:
http://weblogs.asp.net/rosherove/archive/2003/11/13/37217.aspx

No idea about Jet, sorry

David
http://homepages.ihug.com.au/~naseby/