Return value stored procedure 1

[Naoise]

Without explicitly passing something in the arg list of a procedure how can you access a RETURN value, for example

create sp1
as
begin

if exists (select foo from foobar)
     begin
         return 1
     end
else
     begin
         return 0
     end

end
go

create procedure sp2
as
begin

declare @foo int

  set @foo = exec sp1

end 
go

I say this as I have a situation where I am using a lot of stored procedures that return values like this and I do not want to have to edit them to add another value to each arg list.

 

[ca8msm]

I think you should be able to use the OUTPUT method. Have a look at the example on Denis' blog here.


____________________________________________________________
Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]

Need help finding an answer? Try the Search Facility or read FAQ222-2244.

 

[Naoise]

Cheers, exactly what I was looking for.

 

[ESquared]

I have to say I don't understand. In the original post you showed exactly how to access return values. Then, you said ca8msm's answer was exactly what you're looking for, only you will have to add another value to each argument list to implement OUTPUT variables, which you said you don't want!

What is going on?

[COLOR=black #d0d0d0]When I walk, I sometimes bump into things. I am closing my eyes so that the room will be empty.[/color]