Creating Stored Procedures with Parameters in SQL Server

Q

How To Create Stored Procedures with Parameters in SQL Server Transact-SQL?

✍: FYIcenter.com

A

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 
   @parameter_1 datatype, 
   @parameter_2 datatype, 
   ...
   @parameter_n datatype
AS
   statement_1;
   statement_2;
   ...
   statement_n;
GO

The following tutorial exercise shows you how to create a stored procedure with one parameter called @url:

USE FyiCenterData;
GO

DROP PROCEDURE Hello;
GO

CREATE PROCEDURE Hello 
   @url nvarchar(40)
AS
   PRINT 'Welcome to ' + @url;
GO

EXEC Hello 'dba.fyicenter.com';
GO
Welcome to dba.fyicenter.com

 

Passing Values to Stored Procedure Parameters in SQL Server

"ALTER PROCEDURE" - Modifying Existing Stored Procedures in SQL Server

Using Stored Procedures in SQL Server Transact-SQL

⇑⇑ SQL Server Transact-SQL Tutorials

2017-01-05, 1343🔥, 0💬