Interested to Buy Any Domain ? << Click Here >> for more details...
What is @@rowcount and with small code snippet explain the
usage?
- 4 Answers
- 14830 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
How is entity framework different from ado.net?
Which object of ado contains datarow datacolumn collection?
How do you find the count of records in a dataset?
What are the major challenges in accessing data from a database?
What is sqldatasource?
If we are not returning any records from the database, which method is to be used?
What is the difference between sqldatareader and sqldataadapter?
What is Data view?
What is aggregate root?
Which provider is used to connect ms access, oracle, etc…?
Explain the difference between ado and ado.net?
What we do with the object of ado.net dataset after using it?
What are all the different methods under sqlcommand?
What is the meaning of executenonquery?
What is an ado connection?
