有没有办法在SQL Server Management Studio Express 2005的查询编辑器中查看空格？ [英] Is there any way to view whitespace in the query editor for SQL Server Management Studio Express 2005?

问题描述

我在Visual Studio 2008中启用了它，但我真的想在SQL Server Management Studio 2005 Express中启用此功能。有谁知道它可能吗？也许在以后的版本中？

编辑：抱歉，我的意思是在文本/查询编辑器中。

解决方案

如果您仍然需要知道如何执行此操作。

编辑注册表项 HKEY_CURRENT_USER ：

  Software\Microsoft\Microsoft SQL Server \ xxx \ Tools \Shell\Text Editor \Visible Whitespace 
  

其中xx是你有的版本（90是2005年，100是2008年）

并将其设置为1以显示。或者对于SQL Server 2012及以上客户端工具，它也在 HKCU ：

  Software\Microsoft\Microsoft\SQL Server Management Studio \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ $ b 
其中SQL Server 2012中的 v   11.0 ，而SQL Server 2014中的 12.0 。
 
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.
解决方案
In case you still need to know how to do this.

Edit the Registry Key in HKEY_CURRENT_USER:
Software\Microsoft\Microsoft SQL Server\xx\Tools\Shell\Text Editor\Visible Whitespace
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:
Software\Microsoft\Microsoft\SQL Server Management Studio\v\Text Editor\Visible Whitespace
where v in SQL Server 2012 is 11.0 and in SQL Server 2014 is 12.0.

                        
这篇关于有没有办法在SQL Server Management Studio Express 2005的查询编辑器中查看空格？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！