Output Parameters
Hello,
How do I call the following proc from Query Analyzer? Something like:
EXEC procOutGetCustomer 'ALFKI', ?, ?, ?
The proc is:
CREATE PROCEDURE procOutGetCustomer(
@CustomerID nchar(5),
@CompanyName nvarchar(40) OUTPUT,
@ContactName nvarchar(30) OUTPUT,
@ContactTitle nvarchar(30) OUTPUT)
AS SELECT
@CompanyName = CompanyName,
@ContactName = ContactName,
@ContactTitle = ContactTitle
FROM
Customers
WHERE
CustomerID = @CustomerID
IF @@ROWCOUNT = 1
RETURN 0
ELSE
RETURN -1;
Thanks,
Bob
|