Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why empty string is returned as 0
Message
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01544288
Message ID:
01544289
Views:
39
This message has been marked as the solution to the initial question of the thread.
A Return statement in SP supports only integer values

>I have a simple stored procedure that declares a variable @ErrorMessage at the top as
>
>declare @ErrorMessage AS VARCHAR(100)
>SET @ErrorMessage = ''
>
>
>At the end of the procedure I return this value as
>
>RETURN @ErrorMessage
>
>
>The value is set to the @ErrorMessage in CATCH block. Then I test this procesure in a query window as following
>
>declare @retval as varchar(100)
>EXECUTE @retval = myproced param1, param2
>print @retval
>
>
>But if there is no problem within the procedure, the value of @retval showing in the query window is 0 (zero). Why not empty string?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform