有没有办法在 SQL Server Management Studio Express 2005 的查询编辑器中查看空格?
我在 Visual Studio 2008 中启用了它,但我真的很想在 SQL Server Management Studio 2005 Express 中启用此功能。有谁知道是否可能?也许在以后的版本中?
编辑:抱歉,我特指在文本/查询编辑器中。
I have it enabled in Visual Studio 2008, but I'd really like to enable this feature in SQL Server Management Studio 2005 Express. Does anyone know if its possible? Maybe in a later version?
EDIT: Sorry, I meant specifically in the text/query editor.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(4)
如果您仍然需要知道如何执行此操作。
编辑
HKEY_CURRENT_USER
中的注册表项:其中 xx 是您拥有的版本(90 是 2005,100 是 2008)
并将其设置为 1 以显示。或者,对于 SQL Server 2012 及更高版本的客户端工具,它也在
HKCU
中:其中 SQL Server 2012 中的 v 为
11.0
,而在 SQL Server 2014 中为12.0
。In case you still need to know how to do this.
Edit the Registry Key in
HKEY_CURRENT_USER
:Where xx is the version you have (90 is 2005, 100 is 2008)
And set it to 1 to show. Or for SQL Server 2012 and up client tools it is also in
HKCU
:where v in SQL Server 2012 is
11.0
and in SQL Server 2014 is12.0
.尝试执行 Ctrl R、Ctrl W(或从菜单编辑 > 高级 > 查看空白激活)。
这是 Edit.ViewWhiteSpace 命令(您可以在“工具”>“选项”>“键盘”中看到它),应将其分配给该键盘组合。事实上,您也可以在命令行窗口中键入此命令 (Ctrl+Alt+A)。
这对我来说适用于 Server Management Studio 11.0.2100.60。
Try doing Ctrl R, Ctrl W (or activate from menu Edit > Advanced > View White Space).
This is Edit.ViewWhiteSpace command (you can see this in Tools>Options>Keyboard) and should be assigned to that keyboard combination. You can in fact also type this command in Command Window (Ctrl+Alt+A).
This worked for me with Server Management Studio 11.0.2100.60.
从 SSMS 2012 开始,此功能可在编辑 > 中找到。 高级 > 查看空白
Starting in SSMS 2012 this is available in Edit > Advanced > View White Space
SSMS(2005年,我不知道2008年)不提供此功能。
但是,您可以使用使用可见字形表示空格和制表符的字体,如下所示: https://i .sstatic.net/Xc1Pw.jpg
我使用了一个名为 Type 的免费字体编辑器Light 复制现有字体,并带有可见的空格字形。
我知道这是一种黑客行为,但只要有意愿,通常就有办法......
SSMS (2005, I don't know about 2008) does not provide this functionality.
However, you could use a font that uses visible glyphs for spaces and tabs, like this: https://i.sstatic.net/Xc1Pw.jpg
I used a free font editor called Type Light to make a copy of an existing font, with a visible space glyph.
I know it's a hack, but where there's a will there's usually a way...