Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

Posted June 28, 2021

Ten Favorite Keyboard Shortcuts in SQL Server Management Studio

By Gregory A. Larsen

If SQL Server Management Studio is your primary tool for writing your TSQL, then you need to learn keyboard shortcuts to be more efficient. 

Keyboard shortcuts are a combination of one or more keys that when entered together perform some task, that would normally take a mouse click, or multiple commands to accomplish.   There are many different types of categories of keyboard short cuts, toolbar, menu, window management and cursor movement to name a few.

  1. F5 – Executes TSQL script 
  2. CTRL+N – Opens a new query window using the existing connection
  3. CTRL+K+C – Comments out a set of lines highlighted 
  4. CTRL+K+U – Uncomments a set of lines highlighted 
  5. CTRL+SHIFT+U – Converts highlighted characters to upper case
  6. CTRL+SHIFT+L – Converts highlighted characters to lower case
  7. CTRL+F – Brings up the search window
  8. CTRL-HOME –Repositions the cursor at beginning document
  9. CTRL-END – Reposition the cursor to end of document
  10. CTRL+G – Allows you to jump to a specific line in a script

These is are my 10 favorite, most-used shortcuts.  If you’d like to see all of the keyboard shortcuts, you can find them here.

Latest Forum Threads
DB2 Forum
Topic By Replies Updated
tables get lock during backup in db2 v9.5 Hamsoo 0 May 8th, 01:03 AM
Query to Pull Last 7 days records from a table vgoushik 0 March 20th, 06:05 PM
DB2 Visual studio addin: ANSI/Unicode problem 10Pints 0 October 5th, 02:08 AM
Things that are everbodys labor day ideas? Lipsett197 0 September 1st, 09:42 AM