SQL Prompt's code snippets will:

• Increase productivity – developers spend less time digging out archive scripts or simply repeating code from scratch.
• Make code safer to execute, easier to understand– by introducing standards and consistency to code modules, for example in terms of structure of any headers, inclusion of guard clauses, and so on.
• Make code faster to test – standardized snippets for testing code, or investigating slow-running code, will mean the results will always be provided in a standard format, which makes for much easier team collaboration during troubleshooting.

Any developer will be familiar with the idea of templates and snippets, which basically allow you to reuse 'chunks' of code, such as function definitions as well as other code modules and routines. Prompt snippets perform a similar function to SSMS templates, but are easier to use and adapt since they provide replacement points for various parameters. You can insert a snippet into a query window, at the cursor position, just by right-clicking and locating the required snippet. You can create a snippet from any highlighted text in an SSMS query window.

SQL Prompt offers many built-in snippets, but you easily create your own custom snippets from any pre-defined block of code. You can store your custom snippets in a central repository, such as GitHub, where they can be accessed by all members of the team.

See: SQL Code Snippets