What is @@rowcount and with small code snippet explain the
usage?
- 4 Answers
- 13530 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
Explain the various objects in dataset.
What is ole data type?
What is the difference between Datareader and Dataset?
Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?
Why do we need ado.net?
How we can provide data to ado.net?
What is the difference between Dataset. clone and Dataset.copy?
What are the main differences between classic ado and ado.net?
What is the difference between sqlcommand and sqldataadapter?
What is variable view?
What is the difference between OLEDB Provider and SqlClient?
What is the difference between ado.net and entity framework?
What is csdl entity framework?
How to bind the controls(best practice) comboboxes to the data in the dataset?
What is difference between datatable and dataset?
