Home > Uncategorized > Create New code templates in SQL Server

Create New code templates in SQL Server

In Management Studio in Menu > Click View > Template Explorer > In this explorer you see different templates. Right click in the Template Explorer > New > Template. It create a new template file, name your template and then right click that template file and click edit. Now you make you new template and save it. That’s it!

Now whenever you click on this new template it create a new Query window with the same code which you write on the template.

Physically file are located on the below path:

C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\Sql

Comments are closed.