EXECUTE @RC =

Hi,

When ever i choose to test a querry in the management studio like so:

DECLARE @RC int

-- TODO: Set parameter values here.

EXECUTE @RC = [Northwind].[dbo].[test]


I am always presented with the --- @RC ---...

What does @RC stand for???

I thought it was row count however, after doing a select @RC i get 0 as a result..

can someone point this out for me...

thanks
erik

change your test query to:

DECLARE @RC int

-- TODO: Set parameter values here.

EXECUTE @RC = [Northwind].[dbo].[test]
SELECT @RC


inside your stored proc,
there should be a RETURN statement,
if it is RETURN @Variable

@RC will be the value of @Variable,
but if you are not using the return with value, then you do not need to worry about this,