newbie question....

[Matt Markus]

I want to write a stored procedure that inserts a record into a table and
return the ID of the newly created record.

Example:

CREATE PROCEDURE SetStatus
AS

Insert Into Status(Success) Values(1)

'here I want to return the new ID that was created when the above statement
executed

Thanks!

[Matt Markus]

Never mind - figured it out

"Matt Markus" <matt_markus@hotmail.com> wrote in message
news:3ca8d54e@10.1.10.29...
> I want to write a stored procedure that inserts a record into a table and
> return the ID of the newly created record.
>
> Example:
>
> CREATE PROCEDURE SetStatus
> AS
>
> Insert Into Status(Success) Values(1)
>
> 'here I want to return the new ID that was created when the above
statement
> executed
>
> Thanks!
>
>

[Michael Tzoanos]

Hope you used @@Identity to return as an output parameter

"Matt Markus" <matt_markus@hotmail.com> wrote:
>Never mind - figured it out
>
>"Matt Markus" <matt_markus@hotmail.com> wrote in message
>news:3ca8d54e@10.1.10.29...
>> I want to write a stored procedure that inserts a record into a table
and
>> return the ID of the newly created record.
>>
>> Example:
>>
>> CREATE PROCEDURE SetStatus
>> AS
>>
>> Insert Into Status(Success) Values(1)
>>
>> 'here I want to return the new ID that was created when the above
>statement
>> executed
>>
>> Thanks!
>>
>>
>
>