自定义默认的“新存储过程"SSMS 2008 模板 [英] Customise default 'New Stored Procedure' SSMS 2008 Template

问题描述

我正在尝试自定义默认查询，当您从 SQL Server Management Studio 2008 上的 Object Explorer 中单击 New Stored Procedure... 时，该查询将放置到位.

I am trying to customise the default query which is put in place when you click New Stored Procedure... from the Object Explorer on SQL Server Management Studio 2008.

我已经找到了如何从 Template Explorer 更改创建存储过程(新菜单)"模板，但这意味着我将不得不继续打开模板资源管理器而不是点击新存储的像往常一样的程序.

I have found how to change the 'Create Stored Procedure (New Menu)' template from the Template Explorer, however this means I will have to keep opening the template explorer rather than clicking on new stored procedure like i usually would.

如何编辑当您单击 New Stored Procedure... 时出现的模板?

How can I edit the template which appears when you click New Stored Procedure... ?

推荐答案

对于 SQL Server 2008，找到这个目录:

For SQL Server 2008, find this directory :

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

或者对于 x64 Windows 上的用户，

or for those on x64 Windows,

C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\Sql\Stored Procedure\

里面有 6 个 .sql 文件:

Within are 6 .sql files:

• 改变
• 创建基础
• 用光标创建
• 使用输出创建
• 从新菜单创建
• 放下

随心所欲地编辑！

对于 SQL Server 2012，

C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\SqlWorkbenchProjectItems\Sql\Stored Procedure

这篇关于自定义默认的“新存储过程"SSMS 2008 模板的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！