CAn I return a varchar value from a msswl stored procedure
Posted on 2006-05-26
Is there a way to get a stored procedure return a varchar value. I noticed that by default they return @rc which is int and cant be converted from inside the stored procedure. I am going crazy over this. Here's my code
create proc qwerty
declare @return_this varchar(255)
SET @sreturn_this = N'return a string'
I know I could do this in a round about way by putting it in a table or something but that seems like an uneccessary overhead....
Any help is deeply appreciated....
Any help is deeply appreciated