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
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Sql Query Analyzer(Short Cut Keys)

Author  Topic 

hafizsohaib
Starting Member

3 Posts

Posted - 2003-01-18 : 05:17:26
hi guys,

i want to know about Sql Query Analyzer's all short cut keys espacialy

How to comment out single line text and block of text???.

czeller
Starting Member

10 Posts

Posted - 2003-01-18 : 11:20:19
select your block (or line) of text, then hit ctrl+shift+c to comment, this simply adds "-- " to each selected line of text (not sure if you can force it to do a multi-line comment).

to uncomment, use ctrl+shift+r

both of these are under the "edit/advanced" menu

a good way to find out about shortcut keys is to simply look in the menus, most actions have some kind of keyboard shortcut tied to them (F5 execute, F8 show/hide object browser, etc...)

Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-01-18 : 23:39:19
ctrl+shift+c does comment multiple lines just as ctrl+shift+r uncomments multiple lines. These are two shortcuts that I could not live without.

Go to Top of Page

Pika
Starting Member

9 Posts

Posted - 2003-01-24 : 03:40:40
This does noet appear to work in SQL 7.0.
Is there a similar command for SQL 7.0?

Go to Top of Page

harshal_in
Aged Yak Warrior

633 Posts

Posted - 2003-01-24 : 04:10:13
ctrl+r removes the result pane,
f8 hides/unhides the database browser.

Expect the UnExpected
Go to Top of Page

Onamuji
Aged Yak Warrior

504 Posts

Posted - 2003-01-24 : 08:11:17
CTRL+E :: executes the highlighted text or all the text in the current window
ALT+F1 :: returns all the objects in the current database

check out this link in books online: mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\qryanlzr.chm::/qryanlzr_7f8z.htm

Go to Top of Page
   

- Advertisement -