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

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

923

What is difference in record set and dataset?

984

What are the difference between readonly vs. Const?

935

What are the ado.net objects?

885

What is openrowset?

913

What is dataset object? Explain the various objects in dataset.

979

How to identify the controls which can be used for binding data?

951

Explain the difference between an ado.net dataset and an ado recordset?

991

How can we perform transactions in .net?

992

What are the advantages of ado.net?

849

What is the meaning of object pooling?

1124

Do you use stored procedure in ado.net?

990

Command objects uses, purposes and their methods.

924

What are the different row versions available in table?

907

What are the data providers in ADO.NET framework?

969