The results above, after the success of the execution to return, the following code
Create proc up_proc3 @ a int, int, @ b @ result int the OUTPUT as
Set @ result=@ + @ b
Declare @ result int
The EXEC up_proc3 5 or 6, @ result output
Print @ result,
There are no parameters if the stored procedure can execute the following successful figure,
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Ask the master to give directions!!!!!
CodePudding user response:
use tempdb for
Go
Create proc up_proc3 @ a int, int, @ b @ result int the OUTPUT as
Set @ result=@ + @ b
Go
Declare @ result int
The EXEC up_proc3 5 or 6, @ result output
Print @ result
Are displayed in SSMS,
Estimate is MAC dbeaver problem, also is the print is not shown, select is,
Suggest still use SSMS back. After all, this is essentially a official things,
The content of the print, on the programming to display is more troublesome, because it is asynchronous,
If you insist on using dbeaver, then don't use the print, all use the select well,
Print @ result
=& gt;
Select @ result