How can I create a module which will execute a stored procedure having multiple output parameters.
//Stored Procedure DDL for sample below:
CREATE PROCEDURE GetProductDetails
@ProductID int,
@ProductLbl varchar(3),
@ProductName nvarchar(40) OUTPUT,
@UnitPrice money OUTPUT,
AS
SELECT @ProductName = ProductName,
@UnitPrice = UnitPrice,
FROM Products
WHERE ProductID = @ProductID and ProductMark = @ProductLbl
How can I write a sql helper for executing this stored procedure getting the output paramters. And
how to use such modules in my DAL.
I tried writing such module but can not get any idea, please if you are using such modules please share with me.
Any kind of help will be appreciated.
Go to the complete details ...