Interested to Buy Any Domain ? << Click Here >> for more details...
What is @@rowcount and with small code snippet explain the
usage?
- 4 Answers
- 14690 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
Which architecture does Datasets follow?
How to identify the updated rows in a dataset?
What is ado oledb and odbc?
What is connected architecture in ado.net?
describe the dataset object in ado.net.
The answers which posted above is not satisfied my requirement? Can some one post teh exact answer? Thanx
If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?
Explain the difference between an ado.net dataset and an ado recordset?
Explain how to call the sql commands asynchronously in ado.net version 2.0?
Explain why edit is not possible in repeater?
Which database is the ado.net sql connection object designed for?
What is the difference between Data adaptor and Data set?
What is difference between Dataview and Datatable?
How to perform sorting on a table in ADO.NET?
What are the advantages of ado.net?
