Re: how to return a string from an Stored Proc
From: Anith Sen (anith_at_bizdatasolutions.com)
Date: 10/04/04
- Next message: W.G. Ryan eMVP: "Re: Could not complete cursor operation because the table schema changed after the cursor was declared"
- Previous message: Aaron [SQL Server MVP]: "Re: "For XML" inside a UDF - how?"
- In reply to: Satya: "how to return a string from an Stored Proc"
- Next in thread: Anith Sen: "Re: how to return a string from an Stored Proc"
- Reply: Anith Sen: "Re: how to return a string from an Stored Proc"
- Reply: Mal: "Re: how to return a string from an Stored Proc"
- Messages sorted by: [ date ] [ thread ]
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
- Next message: W.G. Ryan eMVP: "Re: Could not complete cursor operation because the table schema changed after the cursor was declared"
- Previous message: Aaron [SQL Server MVP]: "Re: "For XML" inside a UDF - how?"
- In reply to: Satya: "how to return a string from an Stored Proc"
- Next in thread: Anith Sen: "Re: how to return a string from an Stored Proc"
- Reply: Anith Sen: "Re: how to return a string from an Stored Proc"
- Reply: Mal: "Re: how to return a string from an Stored Proc"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
