問(wèn)題描述
查詢窗口中是否有可以在另一個(gè)查詢窗口中打開存儲(chǔ)過(guò)程的命令?
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.
目前我必須執(zhí)行以下多個(gè)步驟:
Currently I have to do the follwowing multiple steps:
打開對(duì)象資源管理器導(dǎo)航可編程性 |存儲(chǔ)過(guò)程右鍵單擊存儲(chǔ)過(guò)程名稱選擇修改
Open Object Explorer Navigate Programmability | Stored Procedure Right Click the Stored Procedure name Select Modify
一個(gè)帶有 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
推薦答案
您試圖在這里混合使用兩種技術(shù).
You are trying to mix two technologies here.
- SQL 和 SQL 語(yǔ)法
- SQL 管理工具
可能無(wú)法使用 TSQL 來(lái)操作 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.
這篇關(guān)于從查詢窗口中，可以將存儲(chǔ)過(guò)程打開到另一個(gè)查詢窗口中嗎?的文章就介紹到這了，希望我們推薦的答案對(duì)大家有所幫助，也希望大家多多支持html5模板網(wǎng)！