SQL Server – Switch Between Result Pan and Query Pan – SQL Shortcut

Many times when I am writing query I have to scroll the result displayed in the result set. Most of the developer uses the mouse to switch between and Query Pane and Result Pane. There are few developers who are crazy about the Keyboard SQL shortcut.

F6 is the keyword which can be used to switch between query pane and tabs of the result pane.

By reading this small article if you have not understood what I mean to say, I suggest that you run any query in SQL Server and press F6 to see its effect. Once used you will understand the usage of it.

SQL Server - Switch Between Result Pan and Query Pan - SQL Shortcut shortcut

Continue Reading…

Recently at one of the conferences I was attending in, a small accident happened – one of the speaker’s hard drives failed. The owner immediately panicked due to this and had no clue what to do. I suggested that he may not be able to show the demos, but can still show a few things with the product. He accepted my suggestion and finished the presentation. Good thing everybody looked satisfied. Little did I know that a small accident was waiting for me later that day.

Read more about this subject over here: SSMS 2012 Reset Keyboard Shortcuts to Default

Reference: Pinal Dave (https://blog.sqlauthority.com)

, ,
Previous Post
SQLAuthority News – Download Tools and Documentation for SQL SERVER
Next Post
SQLAuthority News – Author Visit – Ahmedabad SQL Server User Group Meeting – November 2008

Related Posts

12 Comments. Leave new

  • Excellent little tip Pinal.

    Reply
  • 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…..

    Reply
  • Imran Mohammed
    December 6, 2008 6:48 am

    @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

    Reply
  • Nice Tip.. Another observation. If you want to go back to the previous tab user Shift + F6

    Reddy P

    Reply
  • lakshminarayanan sampath
    December 25, 2008 9:49 pm

    CTRL+R is another keyboard shortcut you can use to switch between query & result tabs.

    Reply
  • Thanks Pinal
    It was useful as the other articles

    Reply
  • Sanjay Monpara
    December 5, 2012 5:18 pm

    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

    Reply
  • Muhammad Mushtaq Sheikh
    November 3, 2016 10:32 am

    Excellent .. You saved us from wasting any more of our time and energy. Thanks buddy..

    Reply
  • JEAN PIERRE PEREZ
    December 1, 2021 9:27 pm

    what about if I want to change F6 for Ctrl+Q? Just to gain microseconds you know

    Reply

Leave a Reply

Menu