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 Keyboard shortcuts.

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.

Reference : Pinal Dave (http://blog.SQLAuthority.com)

About these ads

9 thoughts on “SQL Server – Switch Between Result Pan and Query Pan – SQL Shortcut

  1. 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…..

    Like

  2. @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

    Like

  3. Pingback: SQL SERVER – Weekly Series – Memory Lane – #005 « SQL Server Journey with SQL Authority

  4. 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

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s