Retrieving primary key value from the table i just inserted

[cctrinh]

Is there a way to retrieve a primary key from the table that I just inserted using Transact SQL? I need to obtain a primary key from the table I just inserted so that I can use that primary key to insert into another table. Any help will be great.

Thank you so much.

 

[gmmastros]

Declare @NewId Integer

-- Put the insert here

Select @NewId = Scope_Identity()





-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom