[thelist] Key ID of Record Just Created?

[Ken Schaefer]

On 8/24/05, Chris Hayes <chris at lwcdial.net> wrote:
> 
> >> DIM valDocID as Integer = SELECT @@IDENTITY
> >
> > I don't know anything about .NET syntax, but basically yes, you will have
> > to
> > run that SELECT query, and assign the results to a variable
> 
> 
> Don'y know if it applies to ASP with MS/MY SQL but might advise a
> transaction lock around the insert and the select to ensure you retrieve the
> correct ID.
> 
> Anybody?

With MS SQL Server, this is unnecessary. Both @@IDENTITY and
Scope_Identity are scoped appropriately. Provided you use the same
connection to the database, you will always get an identity value that
you created, and not one created by someone else.

Cheers
Ken