Post reply

Management Studio SQL editor

  • September 17, 2008 at 2:58 am

    #103582

    Hi.

    In Query Analyser (SQL 2000) you could highlight a selection of code and comment it out all in one go by pressing (Shift Control and C) together. Does similiar functionality exist in the 2005 Management Studio?

    thanks for your help!

    Paul

  • September 17, 2008 at 3:08 am

    #872871

    You need to press Ctrl K then C (while still holding down Ctrl). Use Ctrl K + U to uncomment.

  • September 17, 2008 at 3:11 am

    #872875

    Thanks Lee... 😉

    Paul

  • September 18, 2008 at 4:38 am

    #873481

    FYI: This Ctrl+K, Ctrol+C/Ctrl+U key combination is the default combination for (un)commenting code in all modern Microsoft code editors. Although it is not the most attractive combination to use, at least Microsoft is consistent 😉 ...

    Cheers!

    [font="Courier New"]
    ------------------------
    MCPD Web Developer, MCPD Windows Developer    [/font]

    Computers are made to solve problems you did not have in the days they didn't exist.

  • September 18, 2008 at 5:21 am

    #873502

    thanks for tip Bert! 🙂

  • September 22, 2008 at 8:22 pm

    #875378

    Another option is to change the keyboard scheme to SQL 2000. Tools, Options, Environment, Keyboard - top of the dialog. I'd grown so accustomed to the shortcuts in QA that choosing the 2000 layout just made sense.

    I wonder now if I'm missing any functionality.

  • September 28, 2008 at 5:08 am

    #878139

    To find all SqlServer 2005 keyboard shortcuts:

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

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply