<div>
The declaration of a cursor does not retrieve any data. You must also use the open cursor call. Also, as cursors are single row retrieves (using FETCH) you should only ever have one row returned.
</div>


<div>
<div class="content wysiwyg-content">
The @ @ rowcount not work using it after a declared cursor. Returns 0 but it should return 1<br />
<br />

<pre><code id="code-8097237">DECLARE @error int
DECLARE @rowcount int

DECLARE Pnr_Actualizables CURSOR FOR
SELECT TOP 150000 RES.resv_id 
FROM dbo.HOMOLOGACION_PNR HOM, dbo.RESV RES
WHERE HOM.rvas_cdg_pnr = RES.rvas_cdg_pnr
AND HOM.rvas_fch_reserva = RES.rvas_fch_reserva


SELECT @error = @@error,@rowcount = @@rowcount
PRINT 'Error 1: '+ convert(varchar,@error)
PRINT 'Registros 2: '+convert(varchar,@rowcount)</code></pre>
</div>
</div>


The @ @ rowcount not work using it after a declared cursor. Returns 0 but it should return 1


The declaration of a cursor does not retrieve any data. You must also use the open cursor call. Also, as cursors are single row retrieves (using FETCH) you should only ever have one row returned.

Using @@rowcount with delare cursor not working sqlserver

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.