The F6 Shortcut moves focus between SSMS panes. I use it when switching between the query editor and results.
When a result grid is long, I often need to move between its contents and the query. Try a harmless query, then press F6. Depending on the active layout, repeated presses move focus through the available document panes.
Customized keyboard mappings and the selected environment scheme can change shortcuts. Check the current SSMS shortcut settings when the key does something different, rather than resetting all shortcuts immediately.
The original conference story
At a conference, a speaker’s hard drive failed before the presentation. I suggested explaining the product features without the prepared demos. The speaker adapted and completed the session. Later that day, an unexpected challenge reached my own session too.
That experience reminded me to look for practical alternatives when plans change. F6 offers one small convenience in SSMS. The pane-switching behavior is the part to test on your installed version.
The original shortcut-reset resource remains below. A keyboard command is worth testing in the actual pane arrangement you use.
Reference: SSMS keyboard shortcuts.
Related reading
A keyboard shortcut is not the lesson by itself, it is a practical way to keep work moving.
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
Discover more from SQL Authority with Pinal Dave
Subscribe to get the latest posts sent to your email.
12 Comments. Leave new
Excellent little tip Pinal.
i want select date without time.
select NextDate from table;
result:
2008-12-16 00:00:00:000
i want remove 00:00:00:000 this from my result…..
Try this
isnull(replace(convert(varchar(12),TCDate,106),’ ‘,’/’),0) as Date
Thanks @Vijay for helping here.
@Ashish
you have to use convert function and then se convert styles.
select convert( varchar(10), NextDate , 126) from table
go
select convert( varchar(10), NextDate , 21) from table
go
select convert( varchar(10), NextDate , 121) from table
Regards,
Imran
Nice Tip.. Another observation. If you want to go back to the previous tab user Shift + F6
Reddy P
CTRL+R is another keyboard shortcut you can use to switch between query & result tabs.
Its not doing switch but just show/hide result pan, thats why we can’t see both at same time
Thanks Pinal
It was useful as the other articles
I have three pane opened (query,result & message).
In this case cursor navigating in circular scenario, here if you want to avoid message pane you can use Shift+F6 go back query pane from result pane
Excellent .. You saved us from wasting any more of our time and energy. Thanks buddy..
what about if I want to change F6 for Ctrl+Q? Just to gain microseconds you know