SQL Server Performance

EXECUTE @RC =

Discussion in 'SQL Server 2005 General Developer Questions' started by erikkl2000, Sep 9, 2006.

  1. erikkl2000 New Member

    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
  2. joechang New Member

    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,
  3. dineshasanka Moderator

    this is deafult and optional.
    Most of the time I am not using it. when a return statment inside the SP, you can use @RC to return that value

    ----------------------------------------

Share This Page