Search code examples
sql-serverssmsssms-18

query executed successfully but did not return number of rows SSMS 18.3.1


Executing simple select statement does not displays the number of rows returned.

It show "Query executed successfully" but do not show how many rows returned.

enter image description here


Solution

  • Click the Messages Tab right next to the Results Tab.

    Should say something like (100 rows affected)