问题描述

查询窗口中是否有可以在另一个查询窗口中打开存储过程的命令?

Is there command inside a Query Window that will open a stored procedure in another Query Window?

即修改 dbo.pCreateGarnishmentForEmployee

i.e. MODIFY dbo.pCreateGarnishmentForEmployee

我使用的是 SQL Server 管理 Studio 2005 和 Red Gate 的 SQL Prompt.

I am using SQL Server management Studio 2005 and Red Gate's SQL Prompt.

目前我必须执行以下多个步骤:

Currently I have to do the follwowing multiple steps:

打开对象资源管理器导航可编程性 |存储过程右键单击存储过程名称选择修改

Open Object Explorer Navigate Programmability | Stored Procedure Right Click the Stored Procedure name Select Modify

一个带有 ALTER PROCEDURE 的查询窗口将打开.

A Query Window will open up with the ALTER PROCEDURE.

正如我上面提到的，我想做的是从查询窗口类型在某种意义上

As I mentioned above, what I would like to do is from a Query Window type in something to the effect of

修改 dbo.pCreateGarnishmentForEmployee

MODIFY dbo.pCreateGarnishmentForEmployee

推荐答案

您试图在这里混合使用两种技术.

You are trying to mix two technologies here.

1. SQL 和 SQL 语法
2. SQL 管理工具

可能无法使用 TSQL 来操作 Management Studio，而这正是您想要的.我怀疑剪切和粘贴是您唯一的选择.

It is probably not possible to use TSQL to manipulate the Management Studio, which is what you appear to want. I suspect cut and paste is your only option.