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

Ask Question
Anonymous User
Anonymous User

Other

I am a content writter !

Message

1 Answers

Anonymous User
Anonymous User 08 Mar 2016
Report Abuse

Input And Output parameter stored procedure

The following example shows a stored procedure with an input and an output parameter. The first parameter in the stored procedure @ProductId receives the input value specified by the calling program, and the second parameter @ProductName is used to return the value to the calling program. The SELECT statement uses the @ProductId parameter to obtain the correct ProductName value, and assigns the value to the @ProductName output parameter.

CREATE TABLE ProductStock


(


ProductId INT PRIMARY KEY IDENTITY(1,1),


ProductName VARCHAR(100),


ManufacturedBy VARCHAR(100),


StockQty BIGINT,


LastUpdated date


)
 
GO
 
SELECT ProductId,ProductName,ManufacturedBy FROM ProductStock
 
Anonymous User
Create Procedure 
 
 -- =============================================
 
 
 


-- Example to Create the stored procedure


-- =============================================


 
 
IF EXISTS (SELECT * FROM sys.objects WHERE type = 'P' AND name = 'Sp_GetProductName')


DROP PROCEDURE Sp_GetProductName

GO


 
 
CREATE PROCEDURE Sp_GetProductName


	@ProductId int,


	@ProductName varchar(100)  OUTPUT
AS
 
SELECT @ProductName =(Select ProductName from ProductStock where ProductId=@ProductId)
 
GO
 
 
 


 
 
 
-- =============================================


-- Example to execute the stored procedure


-- =============================================


 
 
DECLARE @ProductName varchar(100);



EXECUTE Sp_GetProductName 1,@ProductName OUTPUT



SELECT @ProductName as ProductName


GO


 
Result :
Anonymous User
 
 
 
 
advertising
Markdown for AI

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

Open .md