@@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
14476 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

Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

951

How do you update a dataset in ado.net?

968

Explain ado.net features? Benefits? Drawbacks?

988

What are the different layers of ado.net?

1014

Explain ado.net features?

989

How would you connect to a database by using .NET?

892

What does ole stand for in excel?

1067

What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?

1277

What is microsoft ole db provider for sql server?

867

What are the advantages of using datalist?

962

How can we save all data from dataset?

941

Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?

1090

What are the major difference between classic ADO and ADO.NET?

941

What is the default Timeout for SqlCommand.CommandTimeout property?

957

What is ado or jdbc?

874