Sql server 2008 codeSnippets or templates advice needed

There are many tools out there some free and some not that offer a codesnippet facility. For some reasons in the company I work for they dont want to install or buy a开发者_开发问答ny third party stuff.

I need to work with just sql server 2008. Is there a way to modify the templates so that when you choose create new SP it loads the custom sp. In a nutshell I would like to know either if I can have code snippets in sql server 2008 without using third party tool or how i can modify templates.

Any suggestions?

Thanks a lot

SQL Server Mangement Studio has always supported the use of templates that can serve as "snippets" - see the MSDN docs on how to use Templates.

This is built-in, free, no cost, no install - just use it. It's quite useful to create your own set of scripts as custom templates for those that you use frequently.

yes

• One example of stored proc template
• Snippets
• SQLServerPedia

In Management Studio, View -> Template Explorer (or just CTRL + ALT + T) In the template explorer, you just locate the template you want to change, right click and "Edit"