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

How would you connect to database using .NET?

998

What is ole db query?

936

What is dataset and datatable in ado.net?

944

How can we load multiple tables in to dataset?

1050

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

900

Does ado.net use odbc?

911

What is microsoft ole db provider for sql server?

881

What are the different ado.net namespaces are available in .net?

965

What are the rules to implement connection pooling?

1018

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

902

What are the different execute methods of Ado.Net?

990

What is sqldatareader in ado.net?

883

What is the default timeout specified for "sqlcommand.commandtimeout" property?

998

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

1009

What is data control techniques?

910