SQL Prompt is an add-in for SQL Server Management Studio and Visual Studio that strips away the repetition of coding.

5 ways coding becomes effortless with SQL Prompt:
NEW! Tab history - save, search, and recover tabs in SSMS
IntelliSense-style code completion
Customizable code formatting
Save code snippets
Refactor SQL code