Keyboard key to Toggle between query and results pane

Question

Post reply

Keyboard key to Toggle between query and results pane

Hardy21

SSCrazy Eights

Points: 9708
More actions
May 29, 2014 at 11:29 pm

#286025

Comments posted to this topic are about the item Keyboard key to Toggle between query and results pane
Thanks

Viewing 15 posts - 1 through 15 (of 19 total)

You must be logged in to reply to this topic. Login to reply

Carlo Romagnano SSC-Insane Points: 22750 More actions · Answer 1

Carlo Romagnano

SSC-Insane

Points: 22750

May 30, 2014 at 12:57 am

#1717669

Also SHIFT+F6. These hot keys are windows standard.

Koen Verbeeck SSC Guru Points: 259155 More actions · Answer 2

Nice question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

free_mascot One Orange Chip Points: 27164 More actions · Answer 3

Good One!

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 4

Good one, thank you for the post.

Agreed F6 and SHIFT+F6 - both works. But they are not the same.

F6 in SSMS is "move to the next pane" - [if the cursor is in the query pane, it moves ahead to the result pane]

SHIFT+F6 in SSMS is "move to the previous pane"

Try this: type "SELECT 1" in the query window, execute, you will see result pane and also message pane. Now try F6 and SHIFT+F6 to see the direction of the focus.

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Carlo Romagnano SSC-Insane Points: 22750 More actions · Answer 5

Raghavendra Mudugal (5/30/2014)
Good one, thank you for the post.
Agreed F6 and SHIFT+F6 - both works. But they are not the same.
F6 in SSMS is "move to the next pane" - [if the cursor is in the query pane, it moves ahead to the result pane]
SHIFT+F6 in SSMS is "move to the previous pane"
Try this: type "SELECT 1" in the query window, execute, you will see result pane and also message pane. Now try F6 and SHIFT+F6 to see the direction of the focus.

Of course, they just differ in direction (next/previous)! But if you are in grid mode with ONE F6 go to result pane, the same with TWO SHIFT+F6 (first goes to the message pane and the second to the result pane).

rhythmk SSCertifiable Points: 7271 More actions · Answer 6

Thanks Hardik for question.

However with the introduction of new keyboard having fn key in place.Microsoft should also change their doumentation.

As here it would be (fn + f6) key would be the answer.

--rhythmk
------------------------------------------------------------------
To post your question use below link

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

crmitchell SSCarpal Tunnel Points: 4557 More actions · Answer 7

Strictly speaking f6 isn't a toggle

It will cycle through all open panes not just those two and if you don't have the results pane visible it won't show it.

You could argue that ctrl-R would better fit as an answer as that is a toggle and will show/hide the results pane.

Igor Micev SSC-Dedicated Points: 33110 More actions · Answer 8

Easy one like for Friday

Igor Micev,My blog: www.igormicev.com

Ed Wagner SSC Guru Points: 287026 More actions · Answer 9

A nice and easy one to end the week.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

NerdherderII SSC Journeyman Points: 95 More actions · Answer 10

NerdherderII

SSC Journeyman

Points: 95

May 30, 2014 at 7:12 am

#1717757

I would agree, ctl + R is the correct answer.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 11

rhythmk (5/30/2014)
Thanks Hardik for question.
However with the introduction of new keyboard having fn key in place.Microsoft should also change their documentation.
As here it would be (fn + f6) key would be the answer.

+10

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

SQLRNNR SSC Guru Points: 281334 More actions · Answer 12

Thanks for the question.

The options of fn+f6 and shft+f6 are great for toggling between the query, messages, and results tabs.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events