Hi
Is possible to return data as a rowset with a single line then?
Or using a temporary table, insert one row with needed data and return data from that table as SELECT {return_column} FROM ... ?
Just ideas.
I've checked, the following code works for a MSDE stored procedure. I don't know if is good or bad, I don't use MSDE (yet)
CREATE PROCEDURE GetOneValue
AS
create table #MyRetValue (ReturnedData Integer)
insert into #MyRetValue (ReturnedData) values (150)
select * from #MyRetValue
drop table #MyRetValue
Dorin
>Dorin,
>Doesn't seem to work in the case of a RETURNed value, but thanks anyway.
>
>Gary
>
>>Hi
>>
>>? SQLEXEC(nConnection,[select * from MyProc])
>>
>>doesn't work?
>>
>>>Hi,
>>>Does anyone know how to get a return value from a SQL Server stored proc? For example, if I have a line of code "RETURN 123" in the proc, how do I receive that? The proc doesn't take an output parameter, just returns a number.
>>>
>>>? SQLEXEC(nConnection,[exec MyProc]) && Returns a 1 showing that the call didn't have an error
>>>
>>>Thanks.
>>>
>>>Gary