我如何只运行我的游标在SQL Server Management Studio中的语句？ [英] How can I run just the statement my cursor is on in SQL Server Management Studio?

问题描述

Toad for Oracle用户很久以前，我已经习惯按下Ctrl + Enter并只执行游标下的语句。

As a long time Toad for Oracle user, I have gotten used to hitting Ctrl+Enter and having just the statement under the cursor be executed.

在SQL Server中管理工作室，击中F5运行整个脚本。要运行当前语句，我必须手动突出显示我想要的语句，然后按F5。

In SQL Server Management Studio, hitting F5 runs the entire script. To run just the current statement, I have to manually highlight the statement I want, and then hit F5.

这真的很讨厌我。有没有人知道一个工具的键盘快捷方式只运行SQL Server上的当前语句？

That is really annoying to me. Does anyone know of a tool with a keyboard shortcut to run just the current statement on a SQL Server? I would change tools just for this one feature.

注意：奇怪的是，即使是免费的 Toad for SQL Server 不允许只运行光标下的语句。

Note: Oddly enough, even the free Toad for SQL Server does not let you run just the statement under the cursor.

推荐答案

好的，所以我从所有这些答案得到的是不，这是不可能的。

修改：

这是我能够做到的：

1 - 下载 SQL Developer

2 - 下载 jTDS驱动程序

3 - 关注这些指令将该驱动程序添加到SQL Developer

3 - Follow these instructions to add that driver to SQL Developer

4 - 使用SQL Developer连接到SQL Server（酷！）

4 - Connect to SQL Server using SQL Developer (cool!)

5 - 运行它，生活是好的

5 - Run it and life is good

这篇关于我如何只运行我的游标在SQL Server Management Studio中的语句？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！