An add-in for SQL Server Management Studio and Visual Studio, SQL Prompt strips away the repetition of coding.
Forget memorizing object and stored procedure names – SQL Prompt autocompletes them.
Stop traipsing about hunting down column dependencies – just check them from the query window.
SQL Prompt takes care of formatting, object renaming, and other distractions, leaving you to concentrate on how the code actually works.
So whether you need to write, refactor, or explore database code, find out how SQL Prompt makes it effortless by trying it free for 14 days.Download free 14 day trial
per userBuy now
with volume discounts of up to 30%
Give us just 30 seconds to show you how SQL Prompt lets you type a lot less, yet do a lot more, by leaving old-fashioned, manual coding behind.
With SQL code completion, customizable code snippets, object tool tips, and synonym support, SQL Prompt strips the tedium from coding and saves you hours of effort.
Type even less by adding your own code snippets to the customizable library and sharing them with your team. That way, everyone can enjoy even faster, even easier coding.
Rename objects without breaking dependencies and encapsulate SQL code as a stored procedure.
Keep your databases tidy and reliable with a complete list of any invalid objects, and unused variables and parameters.
To fix them, you can script objects as
ALTER directly from queries.
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.
|Code completion with statement expansion||x||x|
|Instant access to schema information||x||x|
|Shareable SQL snippets||x||x|
|Find invalid SQL Server objects||x|
|Tab history - save, search, and recover tabs||x|
|Select column dependencies||x||x|
|Auto-generation of aliases||x||x|
|Script as ALTER from query window||x|
|Format SQL code||x||x|
|Decrypt encrypted objects||x||x|
|Find unused variables and parameters||x||x|
|Qualify object names||x||x|
|Smart rename refactoring||x|
|Encapsulate as stored procedure||x|
“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.”
This handy quick reference guide includes our top 12 snippets, and shortcuts and tips for code-completion, formatting, navigation, and refactoring SQL code in SSMS and Visual Studio.Download the quick reference guide (PDF 256KB)