SQL Prompt makes it happen in the query editor with Ctrl+K, Ctrl+Y. The same key combination in SSMS is reserved, but doesn’t reformat a query (apparently it’s a feature in the “text editor” only). NET code, Ctrl+K, Ctrl+D “prettifies” the code–fixing indents, line breaks, and so on to improve readability. SQL Prompt gives you more options for its behavior that SSMS’ Intellisense, also.ģ. SQL Prompt is also alias-aware, and will make suggestions for temporary tables and procedure variables, including table variables. The suggestions are filtered in the same way as you type the object name, making it very quick to select what you need with only a few keystrokes. Then user views, system objects, and so on. All user tables are listed first, arranged alphabetically. In contrast, SQL Prompt groups objects by type, then alphabetically. This will get annoying fast if you’re a down-arrow user, or if your tables start with the same letters as system objects. SSMS’ Intellisense orders everything alphabetically–user tables and views are mixed in with system objects. In SSMS, the implementation isn’t as smooth. IntelliSense is Microsoft’s trademark for the “what we think you mean to type next” feature, and in. As with snippets, SQL Prompt has a better implementation of an existing SSMS feature. Here’s how to insert a snippet, and here’s how to create one. It’s true that since 2012, SSMS has also had snippets, but working with them is clunky. You can even easily make your own snippets, or grab one from the community repository at. How many times do you start with “Select * From” or “Select Top 100 * From”? How often do you love typing all of that, each time, over and over and over again? Work smart with SQL Prompt, and type “ssf” or “st100” followed by any key, and have those commands auto-expanded for you. Either way, if you use SSMS, SQL Prompt will make your life better. One of my favorite tools is SQL Prompt, an SSMS plugin that adds “missing” functionality, or has similar features which work better. NET as well as my SQL Server and MySQL work. Working smarter is one of the reasons I’m such a fanboy of RedGate’s products, both for my. That’s not to say I’m lazy–quite the opposite–it’s to say we all need to put some time into working smarter.