This page has 0 threads | Add post

Wise Owl guides and tutorials

Running Stored Procedures

Written by Andy Brown

In this tutorial

Methood 1 - Selecting the Stored Procedure Name
Method 2 - Right-Clicking on the Procedure Name
Method 3 - Execute the Stored Procedure in a Query

Let's suppose that you've created the stored procedure described in the previous part of this tutorial:

CREATE PROC spListActors

-- display list of actors

SELECT

ActorName,

ActorGender

FROM

tblActor

You now want to run the spListActors stored procedure, to list out its contents. Below are 3 ways to do this.

Methood 1 - Selecting the Stored Procedure Name

The simplest way to run a stored procedure is just to select its name and press F5:

Just double-click on the name of the stored procedure to select it, and then execute it like any other SQL query.

This will produce the results of the SELECT statement included in the procedure:

The first few rows returned by running the procedure.

Note that this method doesn't work if your stored procedure takes parameters (then again, we haven't covered parameters yet!).

Method 2 - Right-Clicking on the Procedure Name

A second way to run a stored procedure is to right-click on its name:

Right-click on the name of the procedure in SQL Server Management Studio and choose to execute it as shown here.

Again, this method doesn't work well if your stored procedure takes parameters.

Method 3 - Execute the Stored Procedure in a Query

The third way to run a stored procedure is to use the EXECUTE command within a query:

-- 3 ways to run procedure to list out actors

EXEC spListActors

EXECUTE spListActors

spListActors

As the above examples show, you can abbreviate EXECUTE to EXEC or - under certain circumstances - miss it out altogether.

Previous
tutorial

Trapping errors and debugging

Previous
part

Creating Simple Stored Procedures

Top of page

Next
part

Modifying or Changing a Stored Procedure

Next
tutorial

User-defined functions

You can learn more about this topic on the following Wise Owl courses:

This page has 0 threads

Add a new post

Head office

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

London

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Manchester

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE

Visual C# training

Excel training courses

Power Automate training

Power BI / DAX training

Python training courses

SQL training courses

VBA (macros) training

Site map

Terms & Conditions

Online tutorials

Tutorials on SQL

Stored procedures