Difference of output returnvalue in SQL Server

1: returnvalue can only return data such as 0, 1,-1, with great limitations. In the stored procedure, the output parameter can return various types of data, which is flexible and convenient.

Returnvalue is used to return the error code, and output is the output parameter of the stored procedure.

Example:

Create proc [DBO]. [pr_testoutput]
@ Intnumber1 int,
@ Intnumber2 int,
@ INTSUM int output,
@ MSG nvarchar (20) Output
As
Begin
Set @ INTSUM = 2
Set @ INTSUM = @ intnumber1 + @ intnumber2

Set @ MSG = 'test message'

End

The test code is as follows:

Declare @ INTSUM int,
@ MSG nvarchar (20 );

Exec pr_testoutput 1, 2, @ INTSUM output, @ MSG output;

Select @ INTSUM, @ msg