Fat Fingers

Hey, I just hit a combination of keys that commented an entire block of code in QA
or is it the flashback thing?
I can't find it in the menus, or is it a total hallucinaction?From the Menu:
Edit | Advanced | Comment Out

From the key board (with thin, delicate, piano fingers):
CTRL + SHIFT + C

To reverse, use:
CTRL + SHIFT + R

Regards,

hmscott

Originally posted by Brett Kaiser
Hey, I just hit a combination of keys that commented an entire block of code in QA

or is it the flashback thing?

I can't find it in the menus, or is it a total hallucinaction?

[Edit comment]: I just noticed that after emphasizing the use of thin, delicate fingers, I promptly fat-fingered CTRL to STRL. Sigh.|||Hey, THANKS!

(Damn, learned something new...again...)

EDIT: Hey look at all those options...

I knew about indeting/de-indeting...

no, really i did...|||Brett, you just saved me a lot of typing and tabbing.

blindman|||Originally posted by blindman
Brett, you just saved me a lot of typing and tabbing.

blindman

Hey, Thank Her Royal Majesty's Ship Cott...[;-)]

HMS Cott! Thanks|||y'er welcome|||Hi all,

I have the 'SQL Query Analyzer Keyboard Shortcuts' from BOL printed and nailed on the wall of my office. It's real handy guide for editing in Query Analyzer.|||My bad!

Credit where credit is due: thanks hmscott.

blindman|||I'm glad my ignorance can be put to good use though...

and OMG...printing short cuts as we speak...

(New most of though through menu items...)

Just thought the commenting/uncommenting was a neat trick...|||one little trick that simply blew me away the first time i discovered it, is that when you have a bunch of crap in the query pane, you can highlight just part of it and hit F5 to execute just that part

useful, for example, to execute one line at a time in a procedure, or to execute the subquery in a complex query, or...

rudy
http://r937.com/|||My favourite one is :

CTRL + X + I + E + M + F

this shortcut fixes all the problems in your code so you'll never have to spend hours looking for that invalid column name!|||Hate to say it, but I was chortling for an hour, when I found you could move that bar in the middle with ctrl+B.|||CTRL + X + I + E + M + F :confused:|||Originally posted by blindman
CTRL + X + I + E + M + F :confused:

i second that|||Originally posted by blindman
CTRL + X + I + E + M + F :confused:

I think it's a joke. ;)

Try touch-typing it.|||try
'CTRL+ALT+DEL+Q+W+E+RT+Y+U+I+O+P+A+S+D+F+G+H+J+K+L +M+N+B+V+C++X+Z'

this is the mother of all shortcuts