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 Kodyaz SQL Server Tools Reviews and Tutorials
Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Windows, Windows Phone, SAP and ABAP, like SAP UI5, Screen Personas, etc.




download SQL Server 2016
download SQL Server 2014
download SQL Server 2012



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 ?
Why don't you use SQL Server Management Studio Query Window keyboard 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

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






Related SQL Resources

SQL Server Articles

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server Tools

MS SQL Server Forums









Copyright © 2004 - 2017 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems