结果窗口的默认大小 SQL Server Management Studio 或替代方案
任何使用 SQL Server 2008 或更早变体的人都知道,当您在窗口中运行命令时,屏幕下半部分会弹出结果窗口。我确实想看到我的结果,但当只有前 10 个结果时,窗口就浪费了。有没有办法改变该窗口的默认大小?
另外,如果 VS 2008 或 2010 中存在这种功能,请告诉我,我将放弃 SQL Server Management Studio。
Any one who uses SQL Server 2008, or earlier variants, knows that when you run the commands in the window the results window pops up for the lower half of the screen. I do want to see my results but when only the first or top 10 results will do have the window is a waste. Is there a way I can change the default size of that window?
Also if this kind of functionality exists in VS 2008 or 2010 let me know and I'll abandon SQL Server Management Studio.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(4)
工具->选项->环境->字体和颜色 ->网格结果
Tools -> Options -> Environment -> Fonts and Colors -> Grid Results
无法更改结果窗格的默认大小。您可能想尝试将结果发送到单独的选项卡。您可以为“结果到网格”和“结果到文本”调整此设置。
在工具下->选项菜单:
There's no way to change the default size of the results pane. You may want to try sending your results to a separate tab instead. You can adjust this setting for both Results to Grid and Results to Text.
Under the Tools -> Options menu:
你不能只使用这个:
你只会得到结果的前 10 行。
can't you just use this:
And you will only get the first 10 lines of your result.
这是我第二次寻找完全相同的刺激物的答案,尽管 Joe Stefanelli 提出的结果选项卡并不是一个坏选择,但我找到了解决此问题的实际方法。
我正在参加 SSM 2017,您所要做的就是从 SSMS 界面中弹出您的查询。换句话说,假设您的 SSMS 在主屏幕上打开,您单击“新查询”,将打开“SQLQuery1.sql”窗口,然后单击该选项卡并将其拖出辅助屏幕上的 SSMS。
从那时起,滚动第一个查询后,只需将结果窗格调整到所需的大小,下次执行时它将保持该大小。
不客气! <(^-^<)
It's the second time that I'm searching for an answer to the exact same irritant and although the results tab, proposed by Joe Stefanelli, isn't a bad option, I found the actual way to fix this.
I'm on SSM 2017 and all you have to do is pop your query out of your SSMS interface. In other words, say your SSMS is open on your primary screen, you click on 'New Query', a 'SQLQuery1.sql' window opens, then u click and drag that tab out of SSMS on your secondary screen.
From then on, after rolling your first query, simply adjust the results pane to the desired size and it'll remain at that size the next time you execute.
You're welcome! <(^-^<)