After you create and deploy a routine such as a stored procedure
or user-defined function, you can run the routine on the database server.
- Optional: Change the run settings. For example, you can specify SQL statements that you want to run before
and after you run the routine.
- In either the Database Explorer or the Data Project Explorer, right-click
the routine that you want to run, and click Run. Note: You should not run routines by using the Run
As option from the pop-up menu in the routine editor. The routine runs on the database server. If the routine has parameters,
a window opens where you can specify parameter values.
- View the results that correspond to the run action in the Data
Output view. You can view messages, parameters, and result sets.