Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

Home Forums How to pass value to the parameter in Stored Procedure? – MindStick
Ask Question

1 Answers

Ashutosh Kumar Verma
Ashutosh Kumar Verma 08 Nov 2021
Report Abuse

Pass values to the parameter in Stored Procedure :

First, we have need to create a Stored Procedure which accept two values as parameter. So define two parameters as @FirstName and @ LastName in stored Procedure which accept the values. 

CREATE PROCEDURE usp_TestDemo(

@FirstName VARCHAR(50),

@LastName VARCHAR(50)

)AS

BEGIN

 SELECT @FirstName AS FirstName,

     @LastName AS LastName;

END

Now, Execute the Stored Procedure, there are two different way to pass the values to parameters in stored procedure. 

1-	EXEC usp_TestDemo 'Steive', 'Markas'

GO

EXEC usp_TestDemo 'Markas', 'Steive'

GO

Ashutosh Kumar Verma

If you observe in above statement values are provide in stored procedure without providing the name of parameters. In this case values are assign to the parameters by order. 

2-	EXEC usp_TestDemo

@FirstName='Steive',

@LastName= 'Markas'

GO

EXEC usp_TestDemo

@LastName='Markas',

@FirstName= 'Steive'

GO

Ashutosh Kumar Verma

In this case order is not matter because values are providing with the parameter name when execute the stored procedure.

advertising
Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md