用于在 sql server management studio 查询窗口中选择当前块或执行当前块的键盘快捷键的加载项？

发布于 2024-11-07 05:27:21 字数 545 浏览 0 评论 0原文

在 TOAD 中，您可以通过键盘快捷键选择当前块或执行当前块......因此，如果您正在处理大型 sql 查询，则在进行修改时，只需按 CTRL+ENTER（或类似的东西，现在不记得了），而不必手动突出显示 sql 块并按下 F5。

我很确定 SSMS 本身不存在这种功能，有人知道任何插件中是否存在这样的功能吗？

抱歉......一些澄清......我正在谈论在查询窗口中工作，其中可能包含：

select * from SomeTable

select * from SomeTable
WHERE
    column1 = 'abc'
AND column2 = 'def'  <--- LET'S SAY MY CURSOR IS SITTING HERE
AND column3 = 'ghi'

select * from AnotherTable
WHERE
    column1 = 'abc'
AND column2 = 'def'
AND column3 = 'ghi'

所以，我只想执行我的光标位于内的语句。

原文

In TOAD, you have keyboard shortcuts where you can select the current block or execute the current block....so if you are working on a large sql query, when you make a modification, you can just do a CTRL+ENTER (or something like that, can't recall right now) rather than having to manually highlight the block of sql and htting F5.

I'm pretty sure this doesn't exist natively in SSMS, anyone know if functionality like this exists in any Add-ins?

Sorry....some clarification....I'm talking about working in the query window, which may contain:

select * from SomeTable

select * from SomeTable
WHERE
    column1 = 'abc'
AND column2 = 'def'  <--- LET'S SAY MY CURSOR IS SITTING HERE
AND column3 = 'ghi'

select * from AnotherTable
WHERE
    column1 = 'abc'
AND column2 = 'def'
AND column3 = 'ghi'

So, I just want to execute the statement that my cursor is within.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

烟花肆意 2024-11-14 05:27:21

加载项 SQL Complete 有这个确切的内容特征。执行当前语句而不选择它。他们的免费快速版本有它，但我也推荐标准版本的附加功能。这可以节省大量时间。

回复收藏 0 原文

谈情不如逗狗 2024-11-14 05:27:21

好的，为了澄清您正在寻找的内容...如果您有以下带有文本选择光标的 T-SQL，如下所示：

DECLARE @Test Int
SET @Test = 1

IF @Test=1
BEGIN
    SELECT TestColumn1 FROM TestTable
    SELECT AnotherTestColumn FROM AnotherTestTable

    SELECT [A Valid Column]

    FROM [A Valid Table]

    SELECT LastColumn FROM LastTable ][ <- CURSOR HERE
END

您将需要某个热键（例如 Ctrl-F5）来执行 SELECT LastColumn FROM LastTable ...？或者 SELECT LastColumn FROM LastTable END （这就是您使用所描述的空白行规则得到的结果）？或者其他什么？中间用换行符分隔的语句怎么样，或者两个语句聚在一起怎么样？

如果您确实想使用空白行来定义“块”，那么作为插件应该很容易做到（示例/教程此处）；另一方面，如果您期望更多的“智能”，这可能是一项困难/复杂的任务，需要 SQL 解析等。

OK, so to clarify what you're looking for... If you had the following T-SQL with text selection cursor as indicated:

DECLARE @Test Int
SET @Test = 1

IF @Test=1
BEGIN
    SELECT TestColumn1 FROM TestTable
    SELECT AnotherTestColumn FROM AnotherTestTable

    SELECT [A Valid Column]

    FROM [A Valid Table]

    SELECT LastColumn FROM LastTable ][ <- CURSOR HERE
END

You would want a certain hotkey (eg Ctrl-F5) to execute SELECT LastColumn FROM LastTable...? Or SELECT LastColumn FROM LastTable END (which is what you would get with the blank row rule you described)? Or something else? How about the statement broken up with a line break in the middle, or the two statements bunched together?

If you really wanted to use blank rows to define "blocks", then that should be pretty easy to do as an Addin (sample/tutorial here); if, on the other hand, you expected a little more "intelligence", this could be a difficult/complex task, with SQL parsing required etc.

回复收藏 0 原文