SQL Prompt Pro

SQL Prompt is an add-in for SQL Server Management Studio and Visual Studio that helps you write, format, navigate and refactor your code

Key Features:

• Autocomplete does the work for you, even for JOINs: As well as making the most common queries, such as SELECTs and INSERTs, quick to write, SQL Prompt completes JOIN conditions for you automatically.
  
• Share your snippets: Type even less by adding your own code snippets to the customisable library and sharing them with your team. That way, everyone can enjoy even faster, easier coding.
  
• Save and recover lost tabs in SSMS: With tab history, you can save, preview and rename tabs and restore tabs previously opened in SSMS. You can pick up work where you left off and start coding again in seconds.
  
• Safely refactor SQL code: Rename objects without breaking dependencies and encapsulate SQL code as a stored procedure.
  
• One-click SQL code formatting: Make code readable and keep developers working to the same standards, with SQL Prompt's single-click, customisable code reformatting.
  
• Actions list: Wrap your code in a block, toggle comments and more with SQL Prompt's new Ctrl-key actions list.
  
• Updated support for Visual Studio: You can now use even more of SQL Prompt's features in Visual Studio 2015. Check out the Features Grid for more detail.
  
• Updated frequently, based on your feedback: SQL Prompt's beta is updated regularly based on feedback from the forums and SQL Prompt UserVoice. If there's a feature you'd love to see, just let us know.