@@ROWCOUNT: Returns the number of rows affected by the last statement.

What is @@rowcount and with small code snippet explain the
usage?

Question Posted / jagan

4 Answers
14816 Views
BirlaSoft, I also Faced
E-Mail Answers

Answer Posted / jagan

@@ROWCOUNT:

Returns the number of rows affected by the last statement.

ex:

UPDATE authors SET au_lname = 'Jones'
WHERE au_id = '999-888-7777'
IF @@ROWCOUNT = 0
print 'Warning: No rows were updated'

Is This Answer Correct ?

4 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which is better entity framework or ado.net?

1113

How can we load multiple tables in a dataset?

1233

What are the parameters that control most of connection pooling behaviors?

1044

Explain the role of data provider in ado.net?

1036

What is ado data control?

1034

What are the main differences between classic ado and ado.net?

1057

What is Data view?

1141

What is the use of sqldatareader class?

1052

What is difference between Dataview and Datatable?

1111

Give an example that shows how to execute a stored procedure in ado.net?

1107

What is difference in record set and dataset?

1150

How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?

1012

Can we do database operations without using any of the ado.net objects?

1039

If we are not returning any records from the database, which method is to be used?

1368

Is it possible to load multiple tables in a Dataset?

1139