如何将存储过程放置在所需的位置? [英] How to place stored procedure in desired location?

问题描述

在 SQL Server 2008 上，如何将我的存储过程放在数据库的Stored Procedures"文件夹中?

On SQL Server 2008, how can I place my stored procedures in "Stored Procedures" folder of my DB?

当我这样声明时:

CREATE PROCEDURE mySchema.myProc

它转到:

MYSERVER\System Databases\Master\Programmability\Stored procedures folder.

如何告诉服务器，将其存储在:

How to tell server, to store it in:

MYSERVER\System Databases\MYDB\Programmability\Stored procedures folder.

如果我这样声明:

CREATE PROCEDURE [myDB].mySchema.myProc

它抱怨:

'CREATE/ALTER PROCEDURE' does not allow specifying the database name as a prefix to the object name.

如果我使用USE"关键字，它会抱怨:

If I use the 'USE' keyword, It complains:

a USE database statement is not allowed in a procedure, function or trigger.

也许问题在于我使用的是 MS Management Studio，并直接连接到服务器，而不是任何特定的数据库?

Maybe the problem is that I'm using MS Management Studio, and connecting directly to the server, and not to any particular DB?

推荐答案

试试下面的

USE MyDb 
GO 
CREATE PROCEDURE mySchema.myProc

这篇关于如何将存储过程放置在所需的位置?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！