Difference Between a Return Parameter And an OUTPUT Parameter

Question

Hi friends,
I want to know What is the difference between a return parameter and an OUTPUT parameter?

Satyapriya Nayak · Answer

Hi Ajay,
Please refer the below link
http://sqlserverpedia.com/wiki/Stored_Procedures_-_Output_Parameters_%26_Return_Values
Thanks

Jaish Mathews · Answer

Lot of discussions across. see one here http://stackoverflow.com/questions/810797/which-is-better-return-value-or-out-parameter