Only available if ‘Add brackets to all identifiers’ option is activated, and will remain available until either the default settings are restored, or ‘Remove unnecessary square brackets’ option is activatedĪpply to the selected text whatever casing options have been setĬomment selected text with the ‘double- dash’ line comment at the start of the lineįormat values from a single column in a result set into a list, for use in the IN clause of a query. Select text firstĪdds square brackets to all identifiers. Update the contents of the location-sensitive suggestion box to reflect the cursor positionĭisplays a submenu that allows you to select a formatting style from any current styles.Īdds commas to a set of values, one per row, Select text range firstĪdds commas and quotes to a set of values, one per row. Navigate up or down the list of filters for suggestions once it has the focus Navigate up or down the list of suggestions once the suggestions list has the focus Open the window listing the issue detailsĮnable the suggestions box so that it appears after a specified time This is a toggleĪccess the window that allows you to choose the code analysis rules that you wish to useĬtrl (hover over squiggly green underline area first) LabelĮnable or disable the code analysis. The Wallchart PDF, which you can download at the bottom, is much prettier…. Here’s the table showing all the Prompt functionality by menu and by keystroke. The keyboard diagram is useful for some of the common actions, but in the end, you need a list, because there is too much there. There is a lot of functionality in SQL Prompt, and a lot of this functionality can be accessed via keystrokes. I’ve highlighted the letters that provide the mnemonic that helps you to remember the right set of characters to hit on that keyboard. For example, it shows how Ctrl+B is the gateway to a whole range of reformatting and refactoring functionality. If you are visually oriented, like me, a diagram is a nice way to learn these keystrokes and helps you to see the patterns. The real power comes when you learn to navigate between All Tabs, Open and Closed with Ctrl and either or, and navigate between tabs with and. You can then flick between the Tab history and the SSMS windows with the Alt key. You quickly learn Ctrl+Q to see the contents of the open tabs. Whoosh! In goes the entire column list, qualified with the name or alias of the origin table source. Go back and write the wildcard character ‘*’ and then hit the Tab Key. Write the SELECT statement, including the FROM clause, but missing out the column list. To do this, you must give Prompt the context. When I’m doing SELECT statements, I like pressing Tab to expand wildcards. I can then request them “on demand”, using Ctrl+Space, whenever I find that I want suggestions, which is often. This gets you a long way, and it pays to avoid these useful key sequences when assigning snippet codes to snippets.Ĭontroversially, perhaps, I keep Prompt’s Suggestions box and column picker in “ quiet mode” (enabled, but set not to pop up automatically). This gets you to the Prompt Action menu, and by tapping the relevant keys, you can bring up the action you want and then tap Enter. Having selected some code in a query pane in SSMS, the most useful key to hit is Ctrl. Both diagrams are available to download, as PDF wallcharts, at the bottom of the article. I’ll provide some diagrams to help to…err…prompt you with the right keystrokes when you find yourself having to reach for the mouse when it isn’t necessary. Even then, there are some things that you just have to know. Ironically, currently the most straightforward way of learning the shortcuts is to from the point-and click menu options the Prompt menu, and the context menu are where most of them are shown. Certainly, when I’m programming in SQL, I really don’t want to have to point and click the whole time so there really isn’t much of an alternative to learning those keystrokes. When you need to work quickly with SQL Prompt, the most obvious time-savers are the keyboard shortcuts. He is a regular contributor to Simple Talk and SQLServerCentral. Phil Factor (real name withheld to protect the guilty), aka Database Mole, has 30 years of experience with database-intensive applications.ĭespite having once been shouted at by a furious Bill Gates at an exhibition in the early 1980s, he has remained resolutely anonymous throughout his career.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |