where @countryID varchar(10), @jobtitle varchar(100) are input paramaters and @numberOfEmployees int is an output parameter of the procedure.
n
1
t
For example, when we execute the procedure pr1 using the following statements, the result should be as in the following figure:
DECLARE @num int;
exec PR1 'UK', 'Sales', @num output;
SELECT @num AS NumberOfEmployees
Results
u
t
or
n
Messages
Number Of Employees
1 35
p
Picture 9.1
Zoom
+ 100%
Close
g
