Output Parameters

[Roshawn]

Hi,

I was wondering what would be the best place to use output parameters.
Should I use them when retrieving one row or multiple rows?

Also, is there a performance penalty if I neglected to use them?

Thanks,
Roshawn

 

[William Ryan]

Perhaps neither. I depends if you need a value back from the Database vs.
the number of affected from an action query. It really depends on what you
want to do, and no, there's not a prohibitive performance penalty. very
little network passed to an from the DB, and very little overhead whatsoever
for the DB to send them back. Learn from the man though ...
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnadonet/html/gazoutas.asp

 

[Val Mazur]

Hi,

It depends. Sometimes you could return scalar value, calculated or prepared
inside of the SP. Sometimes you could return some sort of status how your SP
finished or error code without throwing error message. There is not specific
way how you required to use it. This is just the way to communicate with the
SP

 

[William \(Bill\) Vaughn]

Someone already pointed to the article, but consider than OUTPUT parameters
(and you can return dozens) are far faster to process than a single row
passed back as a rowset. No, they can't be used where you need a rowset, but
they can pass back aggregates or other information that's computed
server-side.


--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________