SQL Server Management Studio（SSMS）中的自定义键盘快捷方式

People love taking shortcuts because it’s the easiest way to do things faster; computers are no exception. Shortcuts, particularly ones performed by keyboard, can save you hours of time once applied properly. Learning keyboard shortcut saves you a lot of time; you’ll definitely notice a boost the productivity because you’re not unnecessarily reaching for a mouse all the time.

人们喜欢捷径，因为这是更快地做事的最简单方法。 电脑也不例外。 快捷方式（尤其是通过键盘执行的快捷方式）在正确应用后可以节省数小时的时间。 学习键盘快捷键可以节省大量时间； 您肯定会注意到生产率的提高，因为您不必一直不必要地伸手去拿鼠标。

I’ve rounded up some of the most common DBA customized keyboard shortcuts in SSMS. The same set of rules can be applied to define one which you feel is most important in your day to day activities. Stay on board and you’ll be mastering these tricks in no time!

我已经总结了SSMS中一些最常见的DBA自定义键盘快捷键。 可以应用同一组规则来定义您认为在日常活动中最重要的规则。 留在船上，您将立即掌握这些技巧！

Keyboard shortcuts are vital and important for anyone who wants to perform an effective work. It’s vital to understand the ins and outs of the IDE as it saves a lot of time. SQL server Management Studio bundled with lots of keyboard shortcuts and I’ve added a useful reference go through in reference section.

键盘快捷键对于任何想要执行有效工作的人都至关重要。 了解IDE的来龙去脉至关重要，因为它可以节省大量时间。 SQL Server Management Studio捆绑了许多键盘快捷键，我在参考部分中添加了有用的参考。

In this article, we will explore the most essential user defined and customized shortcuts which will make our daily life more easy and intuitive. The use of SQL Server Management Studio let the users define and design the customized short key to perform various day to day activities. This article outlines the tips and tricks that one can apply to perform effective work with minimal efforts

在本文中，我们将探索最基本的用户定义和自定义快捷方式，这些快捷方式将使我们的日常生活更加轻松和直观。 使用SQL Server Management Studio，用户可以定义和设计自定义的快捷键，以执行各种日常活动。 本文概述了一些技巧和窍门，人们可以用这些技巧和窍门以最少的努力执行有效的工作。

We are going to see how the custom queries can be used as query shortcuts in SSMS. There are plenty of the resource are available to discuss the default shortcuts that are bundled with SSMS IDE but the following section talks about customization and parameter passing through keyboard shortcuts under various scenarios is discussed in detail.

我们将看到如何将自定义查询用作SSMS中的查询快捷方式。 有大量资源可用来讨论与SSMS IDE捆绑在一起的默认快捷方式，但以下部分将详细讨论在各种情况下通过键盘快捷方式进行自定义和参数传递的问题。

If you are a Developer/DBA we always tend to achieve the results in simple and smarter way. This is where we are going for keyboard shortcuts. We do have an option available in SSMS to set and define the rules to use the keyboard shortcuts.

如果您是开发人员/ DBA，我们总是倾向于以简单，智能的方式获得结果。 这是我们要使用键盘快捷键的地方。 我们确实在SSMS中提供了一个选项来设置和定义使用键盘快捷键的规则。

The below the steps to create customized key board shortcuts

下面是创建自定义键盘快捷方式的步骤

Open SSMS->Go to Tools -> Select Options.

打开SSMS->转到工具->选择选项。

Go to Environment -> Keyboard -> Query Shortcuts

转到环境->键盘->查询快捷方式

On the right, in the query shortcuts pane, we can see some shortcuts which are by default in SSMS. Now, if you need to add a new one, just click on any column under Stored Procedure column. In this case we have added ctrl+3 for sp_helptext. The sp_helptext is a procedure that displays the definition of objects.

在右侧的查询快捷方式窗格中，我们可以看到SSMS中默认设置的一些快捷方式。 现在，如果需要添加一个新的，只需单击“存储过程”列下的任何列。 在这种情况下，我们为sp_helptext添加了ctrl +