@@ROWCOUNT

  • Thread starter Thread starter IntraRELY
  • Start date Start date
I

IntraRELY

I am trying to return the Row Count from a stored proc Here is the sp

CREATE PROC
AS
SELECT * FROM accounts
RETURN @@ROWCOUNT
GO

Here is where I am pulling the return value, but I am getting nothing??? All
the return parameters are set correctly.

lblMessage.Text = cmdDepositoriesRetrieve.Parameters("@returnvalue").Value

TIA,

Steve Wofford
www.IntraRELY.com
 
then, to exec in Query Analyzer,
DECLARE @MYVAR INT
EXEC MYPROC (@MYVAR OUTPUT)
Click to expand...

Should be:
then, to exec in Query Analyzer,
DECLARE @MYVAR INT
EXEC MYPROC (@MYVAR OUTPUT)
select @myvar
 
Back
Top