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 difference between executenonquery and executequery?
How can we load multiple tables in a dataset?
Command objects uses, purposes and their methods.
What are the objects of ado.net?
How to pass multiple tables in datasets simultaneously?
Why do we use sqldataadapter?
What is shadow copy?
What are the different ado.net namespaces are available in .net?
Which method is used to sort the data in ADO.Net?
Which is better entity framework or ado.net?
What is meant by executenonquery?
What is command class in ado.net?
What is the difference between oledb sql server and oledbdotnet provider?
Does sqlclient and oledb class share the same functionality?
Which architecture does Datasets follow?