问题描述
查询窗口中是否有可以在另一个查询窗口中打开存储过程的命令?
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.
- SQL 和 SQL 语法
- 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.
这篇关于从查询窗口中，可以将存储过程打开到另一个查询窗口中吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！