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 ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is ado.net connection?
What is adodb dll?
Explain all the classes those are used for database connections between sql server and asp.net?
What are the data access namespaces in .NET?
What is sql command in ado net?
What is the use of SqlCommandBuilder?
What is datatable in ado.net?
What is the difference between ado.net and entity framework?
How can we load multiple tables in to dataset?
Explain the difference in an abstract class and an interface?
How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?
Define table relations?
What is difference between ado and other data object?
Why is ADO.NET serialization slower than ADO ?
What are the advantages and drawbacks of using ado.net?