Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
landau66
Yak Posting Veteran
61 Posts |
 Posted - 2014-02-09 : 13:47:38
|
| Hello everyone!Is there something like a SP that has the possibility of two or more output parameters? Acctually I need two values of one row or even the whole row. How can I get a row back?Thank you very much!landau |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-02-09 : 19:13:51
|
| Yes you can have many output parameters. And to get a row back, you just run a SELECT statement.Are you getting an error?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-02-10 : 05:20:48
|
quote:
Originally posted by landau66
Hello everyone!Is there something like a SP that has the possibility of two or more output parameters? Acctually I need two values of one row or even the whole row. How can I get a row back?Thank you very much!landau
you can have as many output parameters as you want. however if your attemp is to return full resultset either use SP with select statement or use table valued function depending on your scenario------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
Is there a SP with two or more output parameters?