ApexSQL complete offers THE best support for code snippets. It has support for creating code snippets directly in SQL (without need to mess around with XML), bind them to keywords...

It's risky to use xp_cmdshell if system is not properly secured. Although easy to use, it's a potential security threat for this SP to be enabled...