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

Describe the command object and its method.

1004

What is an ado connection?

975

What is bubbled event?

974

What are the important features of ado.net 2.0?

1076

What is microsoft ado.net?

1157

Explain the difference between sqlcommand object and command behavior object?

1088

What is oledb driver?

936

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

940

What is oledb connection?

988

What is ado.net full form?

991

What is difference in record set and dataset?

1077

What is sqldatasource?

929

Why is stored procedure used in ado.net?

1125

Compare Data Reader & Dataset in ado.net?

1001

What is ado in agriculture?

966