Skip to main content

Command Palette

Search for a command to run...

TIL: Rider can show SQL Results inline within query

Updated
1 min read
TIL: Rider can show SQL Results inline within query

I use JetBrains Rider as my primary IDE, and I like to use it for as much of my development process as possible. I prefer to avoid jumping around between multiple different applications if I can, so when I want to run some SQL I typically use Rider rather than opening SSMS or Azure Data Studio (or the VS Code plugin which is replacing it).

Today I learnt that Rider contains an option to display the results of a query inline within the SQL window. I don’t think this will be my default way of viewing SQL results, I think I’ll stick with a table of data at the bottom of the window, but I can definitely see this being useful for debugging long queries by checking the results at each step of a lengthy process. I always like to know what tools are available even if I don’t have imminent plans to use them, because it opens up more possibilities for the future.

Details of how to enable this (either per–file or for all queries) are in the official documentation.

More from this blog

T

Tim talks tech

76 posts