Re: ASP Problem retrieving new identity from Stored Procedure
thank you. but i think i was a bit unclear. in my asp script i use the
call stored procedure from SQL( that's ok, it returns the identity val)
mycommand.Parameters.Append mycommand.CreateParameter ("@TmpV",adInteger,adParamReturnValue)
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...
"John Knoop" <email@example.com> wrote:
>This would be the SQL Statement:
>SET NOCOUNT ON;
>INSERT INTO () VALUES ();
>SELECT @@Identity AS LastID;
>SET NOCOUNT OFF;
>"Gia" <firstname.lastname@example.org> wrote in message
>> 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
>> i can call that value from my asp Script. Suggestions? examples are
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center