@@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
14477 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 do you know about ado.net's methods?

1057

What is commandbuilder in ado.net?

956

What connected data?

892

What is ado.net objects?

910

What is ado.net architecture?

879

What is bubbled event?

916

What are datareaders?

919

What are the different ado.net namespaces?

1016

List all the steps in order, to access a database through ado.net?

1033

What is connection pooling and what is the maximum pool size in ado.net connection string?

902

What are the Data providers in ADO.Net?

956

How to pass multiple tables in datasets simultaneously?

1014

What does executereader return?

899

How to generate a single aggregate?

941

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

1011