Search code examples
sqlt-sqlssms

Select Statement in SSMS does not show results

I came across a weird behavior in SSMS 18 wherein my select statement does not show any grid as a result even thought my results to grid is enabled. What might I be missing?

enter image description here

enter image description here

Edit:

All options are unticked in query results -> results to grid.

enter image description here

SETPARSEONLY and SETNOEXEC are unticked in query execution -> advanced.

enter image description here

Solution

  • Your screenshot shows that you have an active text-selection covering UPDATE statement; the Execute button in SSMS will only run the entire file/script/batch when no text is currently selected, otherwise it only executes the currently selected text as its own batch/script.

    ...so in your case, you've been running only the UPDATE statement without the preceding SELECT hence why you get the "(3 rows affected)" mmessage but no query results grid.

    So de-select all text first, then press F5.