如何在“编辑前 200 行"中更改 SQL在 SSMS 2008 [英] How to alter SQL in "Edit Top 200 Rows" in SSMS 2008

问题描述

在 SQL Server 2008 Management Studio 中，当我右键单击数据库表并选择选择前 100 行"时，我可以例如轻松地向 SQL 添加ORDER BY"语句.这很好.

In SQL Server 2008 Management Studio, when I right click on a database table and choose "Select Top 100 Rows", I can then e.g. easily add a "ORDER BY " statement to the SQL. That works fine.

但是当我选择编辑前 200 行"时，我无法更改 SQL(这使得很难找到和编辑记录刚刚添加到那里的 10,000 个中.

But when I do choose "Edit Top 200 Rows", I don't have the ability to alter the SQL (which makes it hard to find and edit a record just added in the 10,000 that are there.

我很确定我能够在 SQL Server 2000 中做到这一点.

I am quite sure I was able to do this in SQL Server 2000.

在 SMSS 2008 中是否有任何方法可以改变编辑记录时记录的显示方式?

推荐答案

如果在 SSMS 中右键单击编辑前 200 行"查询的任何结果，您将看到选项窗格 -> SQL".然后它会显示运行的 SQL 查询，您可以根据需要对其进行编辑.

If you right click on any result of "Edit Top 200 Rows" query in SSMS you will see the option "Pane -> SQL". It then shows the SQL Query that was run, which you can edit as you wish.

在 SMSS 2012 和 2008 中，您可以使用 Ctrl+3 快速到达那里.

In SMSS 2012 and 2008, you can use Ctrl+3 to quickly get there.

这篇关于如何在“编辑前 200 行"中更改 SQL在 SSMS 2008的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！