SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software
Development resources, articles, tutorials, code samples, tools and downloads for ASP.Net, SQL Server, Reporting Services, T-SQL, Windows, AWS, SAP HANA and ABAP

Define Keyboard Shortcuts in SQL Server Management Studio to Simplify T-SQL Commands

Did you get tired of coding the same statement like "SELECT * FROM ...", or "sp_helptext ...", or "sp_help ...", etc repeatedly?
Why don't you use SQL Server Management Studio Query Window keyboard shortcuts or Keyboard Query Shortcuts?
Just highlight the SQL Server object name on Query Editor window and press shortcut keys.

Follow the following menu options in Microsoft SQL Server Management Studio IDE.
Tools > Options...
When Options configuration dialog screen is displayed drill-through Environment > Keyboard or on SQL Server 2017 Management Studio Environment > Keyboard > Query Shortcuts

SQL Server professionals will see a screen similar to shown below. The default keyboard shortcuts defined are :
Alt+F1 for sp_help,
Ctrl+1 for sp_who, and
Ctrl+2 for sp_lock

SQL Server Management Studio Options for keyboard shortcuts

Note : One important thing about this keyboard shortcuts is if you make a change on the list you must open a new Query Editor window to see the changes affected.

But since I use sp_helptext system stored procedure to see the create script of a SQL Server stored procedure, sql function, etc I added sp_helptext in this list as well.
Ctrl+F1 for sp_helptext

An other SQL statement that I frequently use is selecting all rows from a database table. Simply "SELECT * FROM [table name]" command. I added this as well like :
Ctrl+3 for select * from

Another addition can be "SELECT TOP 1 * FROM" in the keyboard shortcut list. If you want to visualize how data is in the target database table.

Here is a list of keyboard shortcuts that I use in SQL Server Management Studio Query Editor windows frequently. I believe you will like this shortcuts and generate yours by using this small user-friendly SQL Server tool

my keyboard shortcuts list for SQL Query Editor window

For my most recent SQL Server 2017 installation, I am using following keyboard query shortcuts:
Alt+F1 for sp_help,
Ctrl+F1 for sp_helptext,
Ctrl+1 for sp_who
Ctrl+2 for sp_lock
Ctrl+3 for select * from
Ctrl+4 for select top 1 * from
Ctrl+5 for select * from sys.tables
Ctrl+6 for select * from sys.procedures
Ctrl+7 for sp_executesql

SQL Server keyboard query shortcuts

SQL Server

SQL Server 2019 Installation
download SQL Server 2019
download SQL Server 2017
download SQL Server 2016
download SQL Server 2014
download SQL Server 2012
MacOS ve SQL Server 2019

Copyright © 2004 - 2021 Eralper YILMAZ. All rights reserved.