Getting the New record Id

[LittleSmudge]

Hi folks.

I'm a visitor from the MS Access and MySQL boards.

I have a requirement to insert/update one table in someone else's SQLServer database.

When I write a new record to an Access database using ADO I can get the auto generated Primary Key easily.

When I write a new record to MySQL via ODBC I get the new Primary Key back using

rstGetId.Open "SELECT Last_Insert_Id() As SNId", MyConn


How do I get the Auto Generated Primary Key back from SQL Server over ODBC when I write a record to this other person's database ?



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[tran008]

Look up @@identity and scope_identity from BOL.

eg...
SELECT @@IDENTITY AS 'Identity'