Not using Visual Studio Enterprise 2017?
You can still try SQL Prompt Pro for 28 days.
Writing SQL code by hand, even with IntelliSense, is frankly pretty dull.
So we made SQL Prompt, which isn’t.
An extension for Visual Studio and SQL Server Management Studio, SQL Prompt strips away the repetition of coding.
As well as autocompleting your code, SQL Prompt takes care of formatting, object renaming, and other distractions, so you can get back to the task in hand.
Whether you need to write, format, or explore database code, SQL Prompt makes it effortless.
Get it free in Visual Studio 2017 Enterprise, or download a free 28-day trial of SQL Prompt Pro to benefit from a host of additional features to help you and your team be more productive.Download free 28 day trial
“I have always been a huge fan of Redgate’s software, and I can confidently say that SQL Prompt is a masterpiece. It has super-enhanced my SQL scripting abilities and has cut my scripting time down to a quarter or less. The tool is very intuitive, and the comprehensive settings allow me to tailor it to my own coding style.”
“The ability to have every DB developer’s code formatted the same way with the execution of a simple command is incredibly helpful to making code reviews more efficient, and to reducing long-term product maintenance costs.”
“Working smarter is one of the reasons I'm such a fanboy of Redgate's products…One of my favorite tools is SQL Prompt, an SSMS plugin that adds "missing" functionality, or has similar features which work better. Either way, if you use SSMS, SQL Prompt will make your life better.”
“I love SQL Prompt. The speed and friendly, intuitive nature of the tool is excellent. The way it handles autocompletion for eg CTEs and combinations of
APPLYand variables makes it a great tool for improving speed and quality for our development efforts. I've recommended it across the entire development team and it is loved by all.”
“It saves huge amounts of time, boosts productivity, enforces common layout and coding standards, and means I can focus fully on the task in hand, while letting the syntax and code take care of themselves.”
“I use SQL Prompt whenever I write any SQL, simple or complex, because it's such a powerful programming aid. I no longer have to constantly look up or memorize obscure object names and SQL commands – instead, I can just browse for them.”
“I am a consultant who specializes in backend systems. I normally spend about 50% of my day in SQL Server Management Studio. Since I started using SQL Prompt, I am at least 30% more productive. Even my clients are starting to notice. I honestly cannot comprehend how I managed to write Transact-SQL prior to this tool.”
Standardize the layout of your SQL code
Customize and share formatting styles to improve readability, quickly identify errors, and more easily make edits without introducing mistakes.
Work wherever you’re most comfortable
Work in SQL Server Management Studio as well as Visual Studio. Support in SSMS includes tab management so you can save and recover lost tabs, and tab coloring by environment so you don’t accidentally execute against Production.
There aren’t many people more qualified at programming SQL than SQL Server MVPs Steve Jones and Grant Fritchey.
Watch how they fared at coding with – and without – SQL Prompt Pro.
|Code Completion Features||Core Edition||Pro|
|Code completion for databases, system objects, keywords, T-SQL commands (e.g. SELECT), stored procedures, parameters, closing parentheses and brackets, aliases|
|Expand singular wildcards|
|Offer suggestions from linked servers|
|CamelCase and mid-string suggestions|
|Code highlighting (matching BEGIN and END, for example)|
|Suggestions for INSERT statements with column lists|
|Auto-complete EXEC statements with parameter lists|
|Highlight matching objects (context-aware)|
|Rename variables and aliases|
|Code Formatting||Core Edition||Pro|
|One click code formatting|
|Create and share customized formatting styles|
|Productivity Features||Core Edition||Pro|
|Built in snippets (SSF = SELECT * FROM, for example)|
|Create, share, and customize frequently used snippets|
|Explore table and function definitions from code|
|Find unused parameters and variables|
|Summarize script in one click|
|Safely split tables|
|Find invalid objects|
|Result Grid shortcuts: Copy as IN clause, Script as INSERT, Open in Excel|
|Execute current statement|
|Execution warnings for DELETE and UPDATE statements|
|Search and reopen tabs (in SSMS only)|
|Tab coloring (in SSMS only)|
|Smart Rename refactoring (in SSMS only)|
|Supported technologies||Core Edition||Pro|
|Visual Studio 2017 Enterprise edition|
|SQL Server 2016, 2014, 2012, 2008, 2008 R2|
|Azure SQL Database|
|Visual Studio 2015, 2013, 2012, 2010|
|SQL Server 2005, 2000|
|SQL Server Management Studio 2016, 2014, 2012, 2008 R2, 2008, 2005, Express edition|
|Azure SQL Data Warehouse||Partial||Partial|
|Analytics Platform System||Partial||Partial|
|Technical Support||Core Edition||Pro|
|Technical Support||Community support via forums, documentation||Full Redgate support:
email, telephone, forums, documentation
If you’re looking to implement DevOps for your SQL Server databases and you’re not sure where to start, get in touch.
Contact us to find out how Redgate’s Database DevOps Solution can help your team deliver value quicker and keep your data safe
Redgate has specialized in database software for 17 years. Our products are used by 804,000 IT professionals, in more than 100,000 companies.
Redgate offers comprehensive documentation and a friendly, helpful support team. An average 87% of customers rate our support 'Excellent'.