如何为 Visual Studio 创建新的存储过程模板？

发布于 2024-07-26 02:22:59 字数 766 浏览 12 评论 0原文

我想为我们的开发团队创建新存储过程的模板。

但是，我似乎无法为数据库对象创建模板项。我知道对于 DLL/C# 相关项目，就像“文件 > 导出模板...”一样简单，

如何将新的 SQL 模板添加到我的数据库项目中？

这是我的模板：

IF EXISTS (select 1 from information_schema.routines where specific_schema = '_SCHEMA_' and routine_name = '_NAME_')
    BEGIN
        print 'Dropping Procedure _SCHEMA_._NAME_'
        DROP  Procedure  _SCHEMA_._NAME_
    END
GO

print 'Creating Procedure _SCHEMA_._NAME_'
GO
CREATE Procedure _SCHEMA_._NAME_
    (
        @parameter1 int
    ,   @parameter2 varchar(10)
    )
AS
BEGIN

END
GO

GRANT EXEC ON _SCHEMA_._NAME_ TO _ROLE_
GO

谢谢！

编辑：哇，这是我第一次有一个问题一整天都没有答案！

是只有我一个人使用项目模板吗？还是没有其他人使用项目模板？我领导了许多开发人员，告诉他们“使用这个模板”与“阅读文档并那样做”更容易。

原文

I would like to create a template for new stored procedures for our development team.

However, I can't seem to create template items for Database objects. I know for DLL/C#-related items, it's as simple as "File > Export Template ..."

How can I add new SQL templates to my Database project?

Here's my template:

IF EXISTS (select 1 from information_schema.routines where specific_schema = '_SCHEMA_' and routine_name = '_NAME_')
    BEGIN
        print 'Dropping Procedure _SCHEMA_._NAME_'
        DROP  Procedure  _SCHEMA_._NAME_
    END
GO

print 'Creating Procedure _SCHEMA_._NAME_'
GO
CREATE Procedure _SCHEMA_._NAME_
    (
        @parameter1 int
    ,   @parameter2 varchar(10)
    )
AS
BEGIN

END
GO

GRANT EXEC ON _SCHEMA_._NAME_ TO _ROLE_
GO

Thanks!

Edit: Wow, it's the first time I've had a question a whole day without any answers!

Is it just me, or does no one else use Item Templates? I lead a number of developers, and it's easier to tell them "use this template" vs. "read the docs and do it that way".

分享到QQ

分享到微博