[ Home  |  FAQ-Related Q&As  |  General Q&As  |  Answered Questions ]

    Search the Q&A Archives

I need to Execute an SP & set its output to the insert...

<< Back to: Sybase FAQ: 9/19 - ASE Admin (6 of 7)

Question by rose
Submitted on 1/14/2004
Related FAQ: Sybase FAQ: 9/19 - ASE Admin (6 of 7)
Rating: Rate this question: Vote
I need to Execute an SP & set its output to the insert statement. This will be occured for multiple rows ...

eg: Insert into stud_12A(id,name,age,class)
select execute appgen..AG_get_key 'app', @new_app_id output , name, age, class from all_stud where class = '12A' ;

I have to work with multiple rows of all_stud table to
stud_12A & insert unique ID generated by this procedure for each row.... Can such combination (with a stored procedure
in insert statement) be possible??
Thanks.




Your answer will be published for anyone to see and rate.  Your answer will not be displayed immediately.  If you'd like to get expert points and benefit from positive ratings, please create a new account or login into an existing account below.


Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer:

FAQS.ORG reserves the right to edit your answer as to improve its clarity.  By submitting your answer you authorize FAQS.ORG to publish your answer on the WWW without any restrictions. You agree to hold harmless and indemnify FAQS.ORG against any claims, costs, or damages resulting from publishing your answer.

 

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.

 

<< Back to: Sybase FAQ: 9/19 - ASE Admin (6 of 7)

[ Home  |  FAQ-Related Q&As  |  General Q&As  |  Answered Questions ]
© 2008 FAQS.ORG. All rights reserved.