What is @@rowcount and with small code snippet explain the
usage?
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 is data control techniques?
What are the various methods provided by the DataSet object to generate XML?
Define isolation?
What is ado asp?
What is Data view?
What is ole in vb?
What is sql command in ado net?
What is bubbled event can you please explain?
Do you use stored procedure in ado.net?
If we are not returning any records from the database, which method is to be used?
Explain the different row versions available in table?
What is row state?
How to create data relations?
What is ado.net full form?
What is meant by executenonquery?