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

Solution

Hi,

You can do a RowCount after the update query. Look at this example:

Any question let me know.

Regards,

Marcelo

Solution

That "query" on the input parameters will count the rows the previous query affected?

Thanks. Will test in a couple of hours.

Regards

Hi,

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.

Regards,

Marcelo

IT... Works!


Thanks!