How to create stored procedure with output parameter in sql server

Question

Anonymous User · Answer

Input And Output parameterand stored procedure The following example shows a stored procedure with an input and an output parameter. The first parameter in the stored procedureand @ProductId receives the input value specified by the calling program, and the second parameterand @ProductName is used to return the value to the calling program. The SELECT statement uses theand @ProductId parameter to obtain the correctand ProductName value, and assigns the value to theand @ProductName output parameter.CREATE TABLE ProductStock
(
ProductId INT PRIMARY KEY IDENTITY(1,1),
ProductName VARCHAR(100),
ManufacturedBy VARCHAR(100),
StockQty BIGINT,
LastUpdated date
)and GOand SELECT ProductId,ProductName,ManufacturedBy FROM ProductStockand Create Procedure and -- =============================================and and and 
-- Example to Create the stored procedure
-- =============================================
and and IF EXISTS (SELECT * FROM sys.objects WHERE type = 'P' AND name = 'Sp_GetProductName')
DROP PROCEDURE Sp_GetProductName
GO
and and CREATE PROCEDURE Sp_GetProductName
	@ProductId int,
	@ProductName varchar(100) OUTPUTASand SELECT @ProductName =(Select ProductName from ProductStock where ProductId=@ProductId)and GOand and and 
and and and -- =============================================
-- Example to execute the stored procedure
-- =============================================
and and DECLARE @ProductName varchar(100);
EXECUTE Sp_GetProductName 1,@ProductName OUTPUT
SELECT @ProductName as ProductName
GO
and Result :and and and and and

forum

How to create stored procedure with output parameter in sql server

Anonymous User

1 Answers

Liked By