Page 1 of 2 12 LastLast
Results 1 to 15 of 16

Thread: Fat Fingers

  1. #1
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Unanswered: 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?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245

    Re: Fat Fingers

    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.
    Last edited by hmscott; 11-26-03 at 12:33.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    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
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Brett, you just saved me a lot of typing and tabbing.

    blindman

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    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
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Dec 2002
    Posts
    1,245

    Cool

    y'er welcome

  7. #7
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311
    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.

  8. #8
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    My bad!

    Credit where credit is due: thanks hmscott.

    blindman

  9. #9
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    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...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  10. #10
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    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/

  11. #11
    Join Date
    May 2003
    Location
    Epsom, United Kingdom
    Posts
    42
    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!
    Shadow to Light

  12. #12
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    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.

  13. #13
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    CTRL + X + I + E + M + F

  14. #14
    Join Date
    Sep 2003
    Posts
    212
    Originally posted by blindman
    CTRL + X + I + E + M + F
    i second that

  15. #15
    Join Date
    Sep 2003
    Location
    London
    Posts
    56
    Originally posted by blindman
    CTRL + X + I + E + M + F
    I think it's a joke.

    Try touch-typing it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •