Re: how to return a string from an Stored Proc

From: Anith Sen (anith_at_bizdatasolutions.com)
Date: 10/04/04


Date: Mon, 4 Oct 2004 11:35:48 -0500

I suggest you read the topic CREATE PROCEDURE in SQL Server Books Online.
There are details on how to use an OUTPUT parameter along with syntax &
examples.

In this case the error suggests you are either using a wrong datatype for
the output parameter or the return value. Execute the procedure like:

DECLARE @v VARCHAR(255)
EXEC hellotest @v
SELECT @v

-- 
Anith