Show Number of Rows Affected

<< Click to Display Table of Contents >>

Navigation:  Menus > SQL >

Show Number of Rows Affected

Previous pageReturn to chapter overviewNext page

Number of records affected by SQL updating statements

SQLs without display output

When executing some SQLs not having a display output as for example INSERT INTO TableName ..., UPDATE TableName ..., DELETE FROM TableName ..., you may like to get a feed back on how many records met the criteria and were affected by execution of the SQL statement or SQL script:

SQL-rows-affected

This dialog will not display, if the SQL script is terminated by a SELECT statement.

If you are running a great number of non-SELECT SQLs being confident of the proper number of rows/records being affected, you may bypass this feed back dialog by deselecting the [Show Number of Rows affected ...].

__________________________
AbsoluteSQL Application Manual - 13 March 2023 - Copyright © 2011 - 2023 Niels Knabe