When writing queries in SQL Server Management Studio (SSMS), developers often need to scroll through the result set displayed in the result pane. Most developers use a mouse to switch between the Query Pane and Result Pane, but there’s a faster and more efficient way using a keyboard shortcut.
F6 is the keyboard shortcut you can use to toggle between the Query Pane and the different tabs of the Result Pane.
If this explanation feels unclear, try running a query in SSMS and then pressing F6 to see its effect. Once you try it, you’ll find this shortcut helpful for improving your workflow.
A Conference Experience: Handling Unexpected Challenges – SQL Shortcut
At a recent conference I attended, a speaker experienced a hard drive failure just before their presentation. Naturally, they panicked and thought the session would be ruined. I suggested they adapt by demonstrating product features without relying on their demos. They followed the advice, completed the session, and left the audience satisfied despite the setback. However, little did I know that my own turn for an unexpected mishap was coming later that day!
For those interested in keyboard shortcuts or resetting them in SSMS, here’s an additional resource:
SSMS 2012 Reset Keyboard Shortcuts to Default. Let us connect more on Twitter.
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
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