Links
Activity
<September 2010>
SunMonTueWedThuFriSat
2930311234
567891011
12131415161718
19202122232425
262728293012
3456789
Blogroll
Archive
Categories
Search
Admin Login
Sign In

I usually run Query Analyzer Sql Server Management Studio with my query results being displayed as text.  But every now and then I really need them to show up in a grid...usually for copying and pasting.  Whenever this happens it's always a process of me sitting there clicking through menus until I remember that you can change that setting under  Tools -> Options -> Query Results -> Default destination for result

What a pain in the ass. 

Today I discovered the keyboard shortcut for making this change and committed it to memory (AKA the yellow sticky note on my monitor).  Here they are for you, and for me when I forget sometime in the near future.

CTRL+D: Results in a grid
CTRL+T: Results as text

Another one that Mark was asking me about the other day... how to insert a NULL into a column when you have the table open in Management Studio.

CTRL+0  (zero)

If you are dead set on never touching the mouse, here is the definitive list from SQL Server 2005 Books Online:

http://technet.microsoft.com/en-us/library/ms174205.aspx

They don't seem to have that insert NULL shortcut listed there though.  I wonder if any others are missing?

Wednesday, February 06, 2008 3:28:38 AM (Pacific Standard Time, UTC-08:00) | Comments [0] | #
www. flickr .com