You can run the stored procedure for testing purposes.
When you run the stored procedure, you can determine whether the run
is successful and whether the result set exists. You can also test
the logic of the routine and the accuracy of output arguments and
result sets. When you run a stored procedure from the workbench, the
workbench calls the stored procedure, and the results are displayed
in the SQL Results view.
To run the stored procedure:
- In the Data Project Explorer view, right-click the stored
procedure, and select Run. The
Specify Parameter Values window opens.
- In the Value field, type D11. D11 is the ID for a department (EMPLOYEE.WORKDEPT) in the EMPLOYEE
database. When you enter this value, the stored procedure will return
rows that match this department ID.
- Click OK.
Messages that show the status of the run are displayed in
the SQL Results view. Result sets are displayed on the Results page.
You can see several rows of data that are displayed on the Results
tab. These results show D11 in the WORKDEPT column.