Simple but useful. Many times when I am writing query I have to scroll the result displayed in resultset. Most of the developer uses the mouse to switch between and Query Pan and Result Pan. There are few developers who are crazy about Keyboard shortcuts.
F6 is the keyword which can be used to switch between query pan and tabs of result pan.
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)
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…..
@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.
Thanks Pinal
It was useful as the other articles