Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I would like to know whether we can use a stored procedure's OUTPUT parameter to a return table as result set?

I would appreciate any practical example using it OUTPUT parameters in stored procedures.

share|improve this question
No; the readonly attribute must be set on all table-valued parameters. In order to return a table you must use a function instead o a stored procedure. –  Pieter Geerkens Jul 15 '14 at 5:56
Thanks for quick response. –  lata Jul 15 '14 at 7:07

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.