Visual Studio 2010:如何更改存储过程模板 [英] Visual Studio 2010: How to change stored procedure template

问题描述

如何在 2010 2008 数据库项目中更改 Visual Studio 的存储过程模板?我尝试更改 C:\Program Files\Microsoft Visual Studio 10.0\Common7\Tools\Templates\Database Project Items 中的模板.这似乎不会影响从数据库项目中的添加项"向导创建的存储过程.我是否遗漏了什么，或者这种更改存储过程模板的方法不再有效?提前致谢.

How does one change the stored procedure templates for Visual Studio in 2010 2008 database projects? I've tried changing the templates in C:\Program Files\Microsoft Visual Studio 10.0\Common7\Tools\Templates\Database Project Items. This doesn't seem to affect the stored procedures created from the Add Item wizards in the database project. Am I missing something or does this method of changing stored procedure templates not work anymore? Thanks in advance.

推荐答案

我知道这不是您想要的确切答案，但作为一种解决方法，您可以在 C:\Program Files\Microsoft Visual Studio 10.0\ 编辑代码片段VSTSDB\Snippets\1033\存储过程

I know it's not the exact answer you're after, but as a workaround you can edit code snippets at C:\Program Files\Microsoft Visual Studio 10.0\VSTSDB\Snippets\1033\Stored Procedure

当您添加新的存储过程时，删除默认代码，在代码窗格中右键单击，然后选择插入代码段".

When you add a new stored proc, remove the default code, right click in the code pane, and select "insert snippet".

不过，我会继续寻找如何编辑新的项目模板，因为这让我发疯.

I'll keep searching though for how to edit the new item templates though, as it's driving me nuts.

我一直在寻找，找到了:C:\Program Files\Microsoft Visual Studio 10.0\VSTSDB\Extensions\SqlServer\Items

I kept searching, and found it: C:\Program Files\Microsoft Visual Studio 10.0\VSTSDB\Extensions\SqlServer\Items

这篇关于Visual Studio 2010:如何更改存储过程模板的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！