The example provided for set proc_output_params off in the set command reference pages includes two errors in the output:
In the first portion, the value of @x returned from the command is erroneously listed as “2.” The value is 1, and appears in bold in the following corrected version:
In the second portion, the return parameters output is erroneously published as “3.” The value is 2, and appears in bold in the following corrected version:
Example 14 Suppresses the output of parameter information:
1> create procedure sp_pout (@x int output) as select @x = @x + 1 2> go 1> set proc_output_params off 2> go 1> declare @x int 2> select @x = 1 3> exec sp_pout @x output 4> print "Value of @x returned from sproc is: %1!", @x 5> go (1 row affected) (return status = 0) Value of @x returned from sproc is: 1
If you do not perform set proc_output_params
off, the output after (return status = 0)
includes
the following:
Return parameters: ----------- 2