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.
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.
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 underTools > Options > Query Execution > Advanced > SET NOEXEC
.SET NOEXEC (Transact-SQL)
Compiles each query but does not execute it.
tvokkenx3#
Check your default "Results To" selected UI element. Make sure it is selected as "Results To Grid".
I ran into this issue and when I looked at the setting under 'Query Result' > 'SQL server' > it was already set as "Results To Grid"
I believe it was when I was trying hot-keys and fat-fingered CTRL+T which changes the results window to "Results To Text"
fjaof16o4#
Check 'General' tab under 'Query Result' > 'SQL server' to see if the 'Default destination for result' is set to 'Result to Grid'