@@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
14657 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 Difference Between Ado And Ado.net?

1031

What is the default provider in ado.net?

960

Explain how to call the sql commands asynchronously in ado.net version 2.0?

927

What providers does Ado.net uses?

1016

What is a datareader object?

1095

What are the methods of XML dataset object?

1023

What is ado.net and its architecture?

1166

What is ado.net in vb net?

916

What are different layers of ADO.Net?

1090

Define data adapter?

947

What are the difference between readonly vs. Const?

1005

What is ado and rdo?

901

What are the uses of Stored Procedure?

1061

What are the ado.net components?

1017

What is namespace in ado.net?

1012