Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Keyboard shortcuts???

Author  Topic 

newman
Starting Member

7 Posts

Posted - 2005-08-15 : 13:38:34
hello friends..

i am a new user to sql,
i was wondering if anyone here will help me to get all the keyboard shortcuts while working on sql...

thankyou

ajthepoolman
Constraint Violating Yak Guru

384 Posts

Posted - 2005-08-15 : 13:50:38
Here are some that I know of:

In Enterprise Manager, when you have a table open and you have added some custom SQL code to narrow down your resultset, Ctrl + R will run your SQL code instead of clicking on the red exclamation point.

In Enterprise Manager, when you are looking at the list of tables, or stored procs you can begin typing the name of the item and the window will jump down to it (not really a short cut)

In Query Analyzer, F8 will open and close the window that lists your databases and tables and such. Ctrl + R will hide/show the result window.

And a handy one, in Query Analyzer highlight a block of code and hit Shift + Ctrl + C and it will put comments in front of the highlighted lines. Shift + Ctrl + R will remove the comments.

Aj

Hey, it compiles.
Go to Top of Page

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2005-08-15 : 14:40:48
put your cursor on a tablename in QA and hit alt-F1 ... I use that one a bit.

Jay White
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-08-16 : 01:24:00
The menus of Query Analyser has the shortcuts keys
Click the menu and see them at right

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -