@@ROWCOUNT

[carlavieira]

Hi,

I have a SP and I put after close cursor this statement:

print str(@@ROWCOUNT) + 'registros incluídos.'

To know how much records are inserted.

But it didn't work. 177 records are inserted and the return was:
0registros incluídos.

Any idea about what can I do to have the number of records inserted.

Thanks

Carla

 

[mimi2]

try
print 'registros incluídos.'
print @@ROWCOUNT

 

[Antzz]

If you are using a cursor then you will have to define your own variable and increment it after each insertion inside the cursor loop to be able to print it later.

@@ROWCOUNT is a SQL System variable which has a value after you execute any SQL Statement which basically lets you know how many rows were affected irrespective of whether they have been deleted/updated/inserted.

 

[carlavieira]

Thank you.

 

[Sqlsa]

Hi,
Try this...

Declare @intNumberOfRecords int

--cursor code


Select @intNumberOfRecords=@@ROWCOUNT

Print rtrim(convert(char(10),@intNumberOfRecords)) +
'Records Processed'

Hope it helps.

Sreenivas
avnsr@hotmail.com
-----------------

 

[Sqlsa]

Hi,
Try this...

Declare @intNumberOfRecords int

--cursor code


Select @intNumberOfRecords=@@ROWCOUNT

Print rtrim(convert(char(10),@intNumberOfRecords)) +
' Records Processed.'

Hope it helps.

Sreenivas
avnsr@hotmail.com
-----------------