Passing Values to Stored Procedure Parameters in SQL Server

Q

How To Provide Values to Stored Procedure Parameters in SQL Server Transact-SQL?

✍: FYIcenter.com

A

If a stored procedure is created with parameters, you need pass values to those parameters when calling the stored procedure with one of two formats listed below:

-- Passing values only
EXEC procedure_name value_1, value_2, ... value_n;

-- Passing name-value pairs
EXEC procedure_name 
   @parameter_1 = value_1, 
   @parameter_2 = value_2, 
   ... 
   @parameter_n = value_n;

The tutorial exercise below shows 2 ways to pass values to stored procedure parameters:

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

EXEC Hello @url='dev.fyicenter.com';
GO
Welcome to dev.fyicenter.com

 

Passing Name-Value Pairs as Parameters in SQL Server

Creating Stored Procedures with Parameters in SQL Server

Using Stored Procedures in SQL Server Transact-SQL

⇑⇑ SQL Server Transact-SQL Tutorials

2016-12-28, 1857🔥, 0💬