Interested to Buy Any Domain ? << Click Here >> for more details...
What is @@rowcount and with small code snippet explain the
usage?
- 4 Answers
- 14658 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
What does executenonquery () method return?
Do you use stored procedure in ado.net?
What are the steps you will take to improve performance?
How can you add or remove rows from the datatable object of dataset?
What is difference between sqldatareader and sqldataadapter?
What is shadow copy?
What is the default timeout specified for "sqlcommand.commandtimeout" property?
What are the advantages using ado.net?
What is ado.net objects?
What is Data Provider?
What connected data?
Which object of ado contains datarow datacolumn collection?
What is the use of data grid?
What are the difference between readonly vs. Const?
What two types of data providers does ADO.NET supply? What determines which one you should use?
