@@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
14825 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 Data view?

1149

Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?

1180

Why is ADO.NET serialization slower than ADO ?

1099

How do I delete a row from a DataTable?

1231

What are the ado.net components?

1065

What is sqldatareader?

977

Is ado.net dead?

1058

What is connection in ado.net?

997

Explain the difference between ado and ado.net?

993

What is sqlconnection and sqlcommand?

1198

What is the difference between linq and ado.net?

1039

What are all the commands used with Data Adapter?

1088

What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?

1062

What is the full form of ado?

1085

What is the difference between ado.net and entity framework?

1094