Autoreplacements

Auto replacements or "snippets" allow you to write frequently used SQL commands more quickly. Type "sel" and press space, enter or tab (configurable in Settings) - and it will be replaced by "select * from". "upd" will be replaced by "update # set where". "#" defines, where cursor will be placed after replacement is done. (This symbol is customizable per Autoreplacement). SSMSBoost Autoreplacements have following features, improving similar functionality of SSMS:
  • Tokens can be case-sensitive
  • It is possible to specify final cursor location, after autoreplacement has triggered
  • You can use standard SSMS parameters like <name, type, default value> in Autoreplacements. SSMSBoost detects these parameters and automatically shows Parameters replacement dialog, saving you additional clicks/keystrokes.
  • Following parameters can be used in Autoreplacements: {User}, {Server}, {Database}, {Connection}, {Timestamp} , {Timestamp:Format} (.Net datetime format). These parameters will be replaced with actual information after Autoreplacement has been triggered. For example you can create an Autoreplacement to place a Username/Timestamp comment into source code.
You can easily add your own Auto-replacements

How it works - sample for "sel" token
Autoreplacement feature in SSMS (select) with SSMSBoost add-in

How it works - sample for "upd" token
Autoreplacement feature in SSMS (update) with SSMSBoost add-in