Hello,
thank you. but i think i was a bit unclear. in my asp script i use the
following:
call stored procedure from SQL( that's ok, it returns the identity val)
mycommand.Parameters.Append mycommand.CreateParameter ("@TmpV",adInteger,adParamReturnValue)
....
mycommand.Execute

i want to know what is the method or property i need to use to get the identity
value from the stored procedure.
for example: mycommand.parameters...
suggestions?

regards,
Gia

"John Knoop" <john.k@home.se> wrote:
>This would be the SQL Statement:
>
>SET NOCOUNT ON;
>INSERT INTO () VALUES ();
>SELECT @@Identity AS LastID;
>SET NOCOUNT OFF;
>
>"Gia" <grjorge_me@yahoo.com> wrote in message
>news:3b30db8d$1@news.devx.com...
>>
>> hello,
>> in my asp script, i'm using a stored procedure to insert new records.
>> This procedure in turn will return the identity. I would like to know
>how
>> i can call that value from my asp Script. Suggestions? examples are
>welcomed.
>>
>> regards,
>> Giovanna
>
>