Rows affected by update sql

Improve this answer. Russ Cam Russ Cam k 30 30 gold badges silver badges bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. ROWCOUNT is used frequently in the loops to prevent the infinite loops and stop the current process when all the target rows are processed.

It is also used for error handling to check the number of affected rows within the statement. In the below T-SQL query, a SELECT query is used to retrieve the top records from the Employee table, and in the same execution, we retrieve the number of rows that are read from the source table, which is rows as in the example, as shown below:.

In the below script. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Linked 8. Related 2. Hot Network Questions. Question feed. Accept all cookies Customize settings.

To store the number of rows updated or deleted etc.. Once the command is executed, store the value of updated or deleted rows into the variable It can be new variable or variables available in class etc.. It just returns 0 or 1. Tags: date , java , sql.