Accessing RETURN values from a Stored Procedure

P

PeteZ

I can access results returned from a stored procedure call OK, my question
is how do you access the value from a RETURN statement in a stored procedure
?

eg. In the Example below - how can I check on the Value -1000 (Customer
not found) ?

@CID = customer id . . . .


-- Does Customer Exist ?
IF NOT EXISTS (SELECT 1 FROM Customers (NOLOCK) WHERE CID = @CID)
RETURN -1000

- Customer Exists, pass back values
SELECT FirstName, LastName FROM Customers WHERE CID = @CID

RETURN 0


thanks,

- peteZ
 
P

peteZ

PeteZ said:
I can access results returned from a stored procedure call OK, my question
is how do you access the value from a RETURN statement in a stored procedure
?

eg. In the Example below - how can I check on the Value -1000 (Customer
not found) ?

@CID = customer id . . . .


-- Does Customer Exist ?
IF NOT EXISTS (SELECT 1 FROM Customers (NOLOCK) WHERE CID = @CID)
RETURN -1000

- Customer Exists, pass back values
SELECT FirstName, LastName FROM Customers WHERE CID = @CID

RETURN 0


thanks,

- peteZ
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Accessing RETURN values from a Stored Procedure 1
HELP No return data from my stored procedure 1
stored procedure and return value 6
combo box on form to update different table 5
Returning a value from a stored proc 6
Stored procedure exception in .NET works fine in Query Analyzer 9
Inconsistent Accesibility - WORKS IN VS2003 FAILS in VS 2005 5
Stored Procedure return records 2

Top