Running routines

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.

To run a routine:

  1. Optional: Change the run settings. For example, you can specify SQL statements that you want to run before and after you run the routine.
  2. 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.
  3. View the results that correspond to the run action in the SQL Results view. You can view messages, parameters, and result sets.
Related tasks
Changing run settings for routines
Related reference
Specify Parameter Values window

Feedback