Output Parameter & Return Parameter in Store Procedure

Output Parameter & Return Parameter in Store Procedure

A return parameter is always returned by a stored procedure, and it is meant to indicate the success or failure of the stored procedure. There turn parameter 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, where as you can only use one return parameter.