@@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
14550 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 ?

10 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between statement and preparedstatement interface?

967

Does ado.net use odbc?

915

What is the difference between linq and ado.net?

965

differences between ADO and ADO.NET

1047

What does executequery return?

927

Which provider is used to connect ms access, oracle, etc…?

963

Explain how do you connect to sql server database without using sqlclient?

954

What is a string variable?

881

What are the steps you will take to improve performance? Will you use dataset or datareader?

944

If a table contains 20000 records. In a page at each time 100 records to be displayed.

855

How to load multiple tables into a dataset?

1009

differance between ADO vs ADO.Net?

1014

What is the use of Dataview?

1092

How many major types of connection objects in ADO.NET?

1003

Give few examples of datareader that is used in different dataproviders.

941