CTRL + K、CTRL + F（格式代码）在 MS SQL Server 中不起作用
格式选择命令在 SQL Server Management Studio 2008 中对我来说不起作用，我想知道是否有人知道如何让它工作。我不知道它是否曾经有效过。
The format selection command isn't working in SQL server management studio 2008 for me and I'm wondering if anyone might know how to get it working. I don't know if it was ever working.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（5）
您是否安装了任何加载项？对于我来说，Ctrl+K、Ctrl+F 将打开 SSMS 工具包查找对话框。因此，发生这种情况可能是因为加载项接管了键盘组合。
另外，“工具”>“工具”下的键盘方案是什么？选项>环境>键盘？如果它已切换到“SQL Server 2000”，您可以尝试将其切换回标准。
最后，我相信在某些情况下，键盘快捷键可能会变得混乱，具体取决于 Visual Studio / BIDS 等的共存和安装顺序。
Do you have any add-ins installed? For me Ctrl+K, Ctrl+F brings up the SSMS Tools Pack find dialog. So perhaps this is happening because an add-in has taken over the keyboard combo.
Also, what is your keyboard scheme under Tools > Options > Environment > Keyboard? If this has been switched to "SQL Server 2000" you might try switching it back to Standard.
Finally, I believe there are cases where the keyboard shortcuts can get messed up depending on the co-existence and order of install for Visual Studio / BIDS etc.
在 SQL SERVER 2014 中
IN SQL SERVER 2014
我知道这篇文章确实很旧，但是对于寻找这个问题答案的人，我要添加以下内容：
Ctrl+K，Ctrl +F 格式代码组合键来自 poorsql.com。他们有一个 SSMS/Visual Studio 插件。截至目前，他们目前支持 SSMS 2017。
I know this post is really old, but for people searching for answers to this question I have this to add:
The Ctrl+K, Ctrl+F key combination for format code comes from poorsql.com. They have a SSMS/Visual Studio plugin. As of this date they currently support up to SSMS 2017.
此功能在 SQL Server Management Studio 上不可用。
您可以使用各种附加组件来执行此操作。我个人使用 ApexSQL。它使您可以选择创建自己的格式模板，以便您的代码始终易于阅读。
This feature isn't available on SQL Server Management Studio.
There are various add-on's you can use to do this. I personally use ApexSQL. It gives you the option to create your own format template, so that your code is always easily readable for you.
检查此链接：
http:// /www.mssqltips.com/sqlservertip/2413/sql-server-management-studio-keyboard-shortcuts-part-1-of-2/
Check this link:
http://www.mssqltips.com/sqlservertip/2413/sql-server-management-studio-keyboard-shortcuts-part-1-of-2/