SQL Server Performance Forum – Threads Archive

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,

---

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 —————————————-

---

]]>