Good morning!
Here's the doubt. I'll be having a timer to update 100 000 rows each run. I want to rerun the timer if the ammount of rows update is equal to 100 000.
The probability of having more rows when I update exactly 100 000 rows in a select top 100 000 (subquery filter), is very, very high. So instead of running another query just like the subquery filter to know if count or length is > 100 000, I would like to use the info that sql server management studio gives you "100 000 rows affeted". Is this available in anyway... or... I'll need to make that query to know that?
Thanks in advance.
Regards
Hi,
You can do a RowCount after the update query. Look at this example:
Any question let me know.
Regards,
Marcelo
That "query" on the input parameters will count the rows the previous query affected?
Thanks. Will test in a couple of hours.
In T-SQL ti will work. For MySql you can use ROW_COUNT(). for Oracle sql%rowcount. BUt I only test this on T-SQL.
IT... Works!
Thanks!
NOTE: For this to work, you MUST set "Expand Inline" to TRUE.