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
Data Source 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 SQL
Results
view. You can view messages, parameters, and result sets.