Databases: Get ID of new record after INSERT 2

[4waystop]

Hi

I've been relentlessly querying google about this and got nowhere, all I can find is how to do it in VB Script or using LiveWire.

What I want to know is once I've inserted a new record to the database (in this case MS SQL Server), how do I find out the Autogenerated indexing number for that record?

Currently I have:

var adoConnection = Server.CreateObject("ADODB.Connection");
adoConnection.Open("Data Source=***;Database=
***;User Id=***;Password='***'");

var perSQL = "INSERT INTO ... VALUES(...)";
RS = adoConnection.Execute(perSQL);

At this point I need to get the ID of the record inserted and then use it in a second insert procedure.

All Help Much Appreciated!!

Thanks

 

[ChrisHirst]

this thread333-846684 or try forum183 MS SQL Programming

Chris.

Indifference will be the downfall of mankind, but who cares?

http://www.candsdesign.co.uk

A website that proves the cobblers kids adage.

http://www.cram-system.com

Nightclub counting systems

So long, and thanks for all the fish.

 

[RhythmAddict112]

All you have to do is SELECT @@Identity
If you google that you should find tons of stuff.

 

[4waystop]

Thanks guys. Turns out it was an SQL problem not a JS/VB problem afterall!

For anyone else looking this page is really useful for explaining proper use of @@IDENTITY:

http://www.kamath.com/tutorials/tut007_identity.asp