Sql server get rows affected update

May 27, Mysql Leave a comment. Add menu. In this case: prep1. In case of Update or delete it will be NUMERIC 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.. Great answer! And if you want to get the output into a variable just declare a table variable and use the INTO keyword.

Show 1 more comment. Samuel Pereira Samuel Pereira 2 2 silver badges 6 6 bronze badges. This won't work if you're updating a column ur also selecting on — Talon. 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. Did you find this article useful and interesting?

Feel free to leave your comment! Artemakis Artemiou. Views: 6, We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. However, you may visit "Cookie Settings" to provide a controlled consent. Read More. Cookie Settings Accept All. Manage consent. Close Privacy Overview This website uses cookies to improve your experience while you navigate through the website.

Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent.

You also have the option to opt-out of these cookies. Add a comment. Active Oldest Votes. 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.