What is parameter in database?

By Arsal Ahmed   Posted on March-20-2018   403


The real power of stored procedures is the ability to pass parameters and have the stored procedure handle the differing requests that are made.  In this topic we will look at passing parameter values to a stored procedure.


Just like you have the ability to use parameters with your SQL code you can also setup your stored procedures to accept one or more parameter values.

One Parameter:

In this example we will query the Person.Address table from the AdventureWorks database, but instead of getting back all records we will limit it to just a particular city.  This example assumes there will be an exact match on the City value that is passed.

USE AdventureWorks
CREATE PROCEDURE dbo.uspGetAddress @City nvarchar(30)
FROM Person.Address
WHERE City = @City

To call this stored procedure we would execute it as follows:

EXEC dbo.uspGetAddress @City = 'New York'

By Arsal Ahmed    20-Mar-2018 Views  403

You may also read following recent articles