Interested to Buy Any Domain ? << Click Here >> for more details...
What is @@rowcount and with small code snippet explain the
usage?
- 4 Answers
- 14701 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
What are the advantages of ado.net?
What is serialization and de-serialization in .net? How can we serialize the dataset object?
What is ado.net and its architecture?
What is ado.net objects?
How to find the given query is optimised one or not?
Can we connect two dataadapters to same data source using single connection at same time?
What are basic methods of dataadapter?
What Is Difference Between Ado And Ado.net?
Give few examples of datareader that is used in different dataproviders.
What is a datagridview?
Why do we use sqldataadapter?
What are the classes in System.Data.Common Namespace?
Explain the role of data provider in ado.net?
Which method in OLEDBAdapter is used to populate dataset with records?
What is the difference between Data adaptor and Data set?
