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