Home >> FAQs/Tutorials >> SQL Server FAQ
SQL Server FAQ - Creating Stored Procedures with Parameters
(Continued from previous topic...)
How To Create Stored Procedures with Parameters?
Very often, you need to create a stored procedure with one or more
parameters. You only supply values to those parameters at the time of
executing the stored procedure.
Stored procedures with parameters can be created with the following syntax:
CREATE PROCEDURE procedure_name
The following tutorial exercise shows you how to create a stored procedure
with one parameter called @url:
DROP PROCEDURE Hello;
CREATE PROCEDURE Hello
PRINT 'Welcome to ' + @url;
EXEC Hello 'dba.fyicenter.com';
Welcome to dba.fyicenter.com
(Continued on next topic...)
- What Are Stored Procedures?
- How To Create a Simple Stored Procedure?
- How To Execute a Stored Procedure?
- How To List All Stored Procedures in the Current Database?
- How To Drop an Existing Stored Procedure?
- How To Create a Stored Procedure with a Statement Block?
- How To End a Stored Procedure Properly?
- How To Generate CREATE PROCEDURE Script on an Existing Stored Procedure?
- How To Get the Definition of a Stored Procedure Back?
- How To Modify an Existing Stored Procedure?
- How To Create Stored Procedures with Parameters?
- How To Provide Values to Stored Procedure Parameters?
- What Are the Advantages of Passing Name-Value Pairs as Parameters?
- Can You Pass Expressions to Stored Procedure Parameters?
- How To Provide Default Values to Stored Procedure Parameters?
- How To Define Output Parameters in Stored Procedures?
- How To Receive Output Values from Stored Procedures?
- How To Create a Local Temporary Stored Procedure?
- Can Another User Execute Your Local Temporary Stored Procedures?