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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.