getting an int id from an inserted record

[Billy Cormic]

Hello,
I would like do an insert into a table. The table has an auto
incrimenting unique int id. After I do the insert how do i get the
unique int id of the record that I just inserted? Is there a straight
forward way of accomplishing this?

Thanks,
Billy

[David Portas]

In SQL2000 use SCOPE_IDENTITY().

In SQL7.0 use @@IDENTITY.

See Books Online for details.

--
David Portas
SQL Server MVP
--

[Simon Hayes]

bi**********@hotmail.com (Billy Cormic) wrote in message news:<dd**************************@posting.google. com>...

Hello,
I would like do an insert into a table. The table has an auto
incrimenting unique int id. After I do the insert how do i get the
unique int id of the record that I just inserted? Is there a straight
forward way of accomplishing this?

Thanks,
Billy

Assuming that you're using MSSQL2000, then you can use the
SCOPE_IDENTITY() function.

Simon

[TinTin]

Use the @@IDENTITY command. For eg.

declare temp int
insert into sometable .....
set temp = @@IDENTITY

Regards,
VS
bi**********@hotmail.com (Billy Cormic) wrote in message news:<dd**************************@posting.google. com>...

Hello,
I would like do an insert into a table. The table has an auto
incrimenting unique int id. After I do the insert how do i get the
unique int id of the record that I just inserted? Is there a straight
forward way of accomplishing this?

Thanks,
Billy

[JK]

Hi,
If you want to manually insert a value into the auto
incrementing id of the table set IDENTITY_INSERT to ON for the table
and then use the INSERT statement else simply supply the values to be
inserted without the autoid column in an INSERT statement. To retrieve
the newly inserted ID use @@identity or scope_identity()
Thanks,
JK

bi**********@hotmail.com (Billy Cormic) wrote in message news:<dd**************************@posting.google. com>...

Hello,
I would like do an insert into a table. The table has an auto
incrimenting unique int id. After I do the insert how do i get the
unique int id of the record that I just inserted? Is there a straight
forward way of accomplishing this?

Thanks,
Billy

[Billy Cormic]

Thanks guys! The scope_identity() worked perfectly!

sq*@hayes.ch (Simon Hayes) wrote in message news:<60*************************@posting.google.c om>...

bi**********@hotmail.com (Billy Cormic) wrote in message news:<dd**************************@posting.google. com>...

Hello,
I would like do an insert into a table. The table has an auto
incrimenting unique int id. After I do the insert how do i get the
unique int id of the record that I just inserted? Is there a straight
forward way of accomplishing this?

Thanks,
Billy

Assuming that you're using MSSQL2000, then you can use the
SCOPE_IDENTITY() function.

Simon

[Billy Cormic]

Thanks everyone for replying. The Scope_identity worked perfectly!

ja**************@hotmail.com (JK) wrote in message news:<d5**************************@posting.google. com>...

Hi,
If you want to manually insert a value into the auto
incrementing id of the table set IDENTITY_INSERT to ON for the table
and then use the INSERT statement else simply supply the values to be
inserted without the autoid column in an INSERT statement. To retrieve
the newly inserted ID use @@identity or scope_identity()
Thanks,
JK

bi**********@hotmail.com (Billy Cormic) wrote in message news:<dd**************************@posting.google. com>...

Hello,
I would like do an insert into a table. The table has an auto
incrimenting unique int id. After I do the insert how do i get the
unique int id of the record that I just inserted? Is there a straight
forward way of accomplishing this?

Thanks,
Billy