Out Parameters in SQL server/Oracle

Hello Rajesh,

CREATE PROCEDURE dbo.MultipleOutputParameters

(

@CustomerID INT,

@CompanyName NVARCHAR(50) OUTPUT,

@ContactName NVARCHAR(50) OUTPUT,

@City NVARCHAR(50) OUTPUT

)

BEGIN

SELECT @CompanyName = CompanyName,

@ContactName = ContactName,

@City = City

FROM dbo.Customers

WHERE CustomerID = @CustomerID

SELECT *

FROM dbo.Orders

WHERE CustomerID = @CustomerID

END

Now let's see how we can call stored procedure with multiple output parameters in SQL Server.

DECLARE @CompanyName NVARCHAR(50)

DECLARE @ContactName NVARCHAR(50)

DECLARE @City NVARCHAR(50)

EXECUTE dbo.MultipleOutputParameters 5, @CompanyName OUTPUT, @ContactName OUTPUT, @City OUTPUT

SELECT @CompanyName AS CompanyName,

@ContactName AS ContactName,

@City AS City

1 Reply

Know the answer? Post it — somebody with the same question will find it here.