This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

SQL stored procedures and passing parameters Part three of a six-part series of blogs
Stored procedures are programs in SQL which allow you to pass parameters to queries and manipulate sets of rows in tables. Find out how to write them with this online training blog! Stored Procedures in SQL Creating Simple Stored Procedures Running Stored Procedures (this blog) Modifying or Changing a Stored Procedure Passing Parameters to Stored Procedures A Worked Example of a Longer Stored Procedure This blog is part of a complete SQL Server tutorial.

SQL stored procedures and passing parameters

Part three of a six-part series of blogs

Stored procedures are programs in SQL which allow you to pass parameters to queries and manipulate sets of rows in tables. Find out how to write them with this online training blog!

Stored Procedures in SQL
Creating Simple Stored Procedures
Running Stored Procedures (this blog)
Modifying or Changing a Stored Procedure
Passing Parameters to Stored Procedures
A Worked Example of a Longer Stored Procedure

This blog is part of a complete SQL Server tutorial.

Posted by Andy Brown on 24 May 2012

Running Stored Procedures

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

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.

Parts of this blog
Stored Procedures in SQL Creating Simple Stored Procedures Running Stored Procedures (this blog) Modifying or Changing a Stored Procedure Passing Parameters to Stored Procedures A Worked Example of a Longer Stored Procedure

Some other pages relevant to the above blogs include:

This blog has 0 threads

Add a new post

Book any course as classroom, onsite or online training, or as one-to-one consultancy

Free resources

Paid services

Getting help

Where we are

Where you are

Online

Transparent reviews

Delivery of courses

Nicer to work with

Reliable and established

Our training courses

C#

Excel

MySQL

Power Apps

Power Automate

Power BI and DAX

Python

Report Builder

SQL

SQL Server

VBA Macros

Other training resources

Blogs

Exercises

YouTube tutorials

YouTube shorts

Test your skills

Consultancy

Courseware

Self-paced courses

Newsletters

Publications

Our training venues

London

Manchester

Across the UK

At your site

Online

Why we are different

Hundreds of published reviews

Small class sizes

Outstanding courseware

Online classroom

(Almost) no cancellations

Wise Owl trainers only

Genuine integrity

Invoices after training

30+ years of Wise Owl

Our top 100 clients

BLOGS BY TOPIC