Welcome to Questionaries, where you can ask questions and receive answers from other members of the community.

Let us know at info@questionaries.org

What is the difference between a return parameter and an OUTPUT parameter?

9 like 0 dislike
Hello
What is the difference between a return parameter and an OUTPUT parameter?
please reply me. i am waiting for your reply.
Thanx
asked 1 year ago by eagles11 (179,830 points)

1 Answer

1 like 0 dislike
 
Best answer
If the applicant is able to answer this question correctly, the odds are good that they have some experience working with stored procedures.
A return parameter is always returned by a stored procedure, and it is meant to indicate the success or failure of the stored procedure. The return arameter is always an INT data type.
An OUTPUT parameter is designated specifically by the developer, and it can return other types of data, such as characters and numeric values. (There are some limitations on the data types that can be used as output parameters.) You can use multiple OUTPUT parameters in a stored procedure, whereas you can only use one return parameter.
answered 1 year ago by DBA-boss (120,990 points)

Related questions