![]() In the following screen, I have highlighted sys.tables and pressed CTRL + 3 to see top 10 records. Highlight any table name and press CTRL + 3 (custom keyboard shortcut) to see the top 10 records. Now we successfully added a custom keyboard shortcut. Likewise, adding sp_helptext query option next to CTRL + 4. Here we are adding select top 10 * from query next to CTRL + 3. You can see that by default SQL server has assigned some keyboard shortcuts in SSMS.ģ.On the right side, we need to add our queries next to defined keyboard shortcuts. ![]() Create Custom Keyboard Shortcut In SQL ServerĢ.In Options box, go to Environment > Keyboard > Query Shortcuts. Here is how we can create a custom keyboard shortcut in SQL Server. Similarly, executing sp_helptext to see the object’s source code. ![]() ![]() We can add our own queries, options as a shortcut for speed-up.Īssuming we need to run a query on various tables repeatedly to get the top 10 records. Moreover, SQL server allows adding custom keyboard shortcuts. You can save a lot of time and efforts by assigning a custom keyboard shortcut to repeatedly executed queries. Important to learn and try them out to speed up the development. SQL Server includes numerous keyboard shortcuts for developers to increase efficiency. Every smart developer should know a handful of keyboard shortcuts to increase productivity. Using a keyboard shortcut saves time and effort.
0 Comments
Leave a Reply. |