Collections:
Passing Values to Stored Procedure Parameters in SQL Server
How To Provide Values to Stored Procedure Parameters in SQL Server Transact-SQL?
✍: FYIcenter.com
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
2016-12-28, 1881🔥, 0💬
Popular Posts:
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...