Results in Grid is not showing in SQL Server

mitkmikd 于 12个月前发布在 SQL Server

关注(0)|答案(4)|浏览(181)

I couldn't see the results in grid pane, so I did the following:

Tools > Options > Query Results > Results to Grid 
      > uncheck the "Discard results after execution" check box

But still I couldn't see the results in grid. I even hit the "Reset to Default" button in same window yet no luck

Please shed some light on this.

sql-server

来源：https://stackoverflow.com/questions/51800800/results-in-grid-is-not-showing-in-sql-server

4条答案

按热度按时间

ruyhziif1#

After dealing with this issue today in SSMS 2017, and nothing seemed to fix it. I looked at all of the setting listed here and even reset the keyboard as mentioned by Mar1009. I would still only see the records affected. I closed SSMS, and re-opened it and it now works fine. so one of the tips above did help, not sure which one it was, but I'd just like to add that it required me shutting SSMS down and reopening it to see the fix.

赞(0）回复(0）举报 12个月前

332nm8kg2#

In my case I had accidentally flipped the NOEXEC flag to true which turns off execution. In the 2019 version you can find it under Tools > Options > Query Execution > Advanced > SET NOEXEC .

SET NOEXEC (Transact-SQL)
Compiles each query but does not execute it.

赞(0）回复(0）举报 12个月前

tvokkenx3#