Here’s some information on SQL Prompt from RedGate, a kickin’ plug-in for SQL Server Management Studio.
This tool is not free – but it’s certainly a productivity enhancer in the long-run for writing clean and easy-to-read SQL with reusable and shared script components (snippets) and sharing team best-practices for SQL. Cost is $369 per seat-license (last I checked) including perpetual upgrades (one year time-limit?); site-licensing is certainly more cost-effective per seat. It’s little brother SQL Search is free, and it’s excellent also. I have used RedGate products including this one for five years and highly recommend this one in particular.
- Reusable common script components or shared snippets that an entire team can edit and share from a common network-share location.
- On one project we had 50+ script components that several coders shared to increase both code quality and time-to-completion.
- Having pre-written blocks or snippets of code really speeds things up
- Meta-data discovery for database objects “Intellisense” style, as you type, including MS_Description (extended-property) values along with object type-characteristics
- More robust Table/View/Column auto-completion, Visual Studio style
- Better script parsing for errors (red-squigglies under errors)
- Supports script refactoring with context-menu (right-click) support
- Supports script formatting with default or custom rule-sets, which helps to improve readability of the average SQL code-base
- Search the database for all scripts using “<search term>”, right within SSMS
- When you install this product, it installs as both a SSMS and Visual Studio plug-in, so you have the functionality for editing SQL in both editors
I can say without hesitation that this product greatly enhances coding productivity and release-script quality for SQL scripting.
They allow for a free 28 day evaluation version for those new to the product.