有没有办法在 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 中启用此功能.有谁知道它是否可能?也许在以后的版本中?

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?

抱歉，我的意思是专门在文本/查询编辑器中.

Sorry, I meant specifically in the text/query editor.

推荐答案

万一你还需要知道怎么做.

In case you still need to know how to do this.

在HKEY_CURRENT_USER中编辑注册表项:

SoftwareMicrosoftMicrosoft SQL ServerxxToolsShellText EditorVisible Whitespace

其中 xx 是您拥有的版本(90 是 2005，100 是 2008)

并将其设置为 1 以显示.或者对于 SQL Server 2012 及更高版本的客户端工具，它也在 HKCU 中:

And set it to 1 to show. Or for SQL Server 2012 and up client tools it is also in HKCU:

SoftwareMicrosoftMicrosoftSQL Server Management StudiovText EditorVisible Whitespace

其中 v 在 SQL Server 2012 中是 11.0，而在 SQL Server 2014 中是 12.0.

where v in SQL Server 2012 is 11.0 and in SQL Server 2014 is 12.0.

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