如何在 SQL Server Management Studio 中快速编辑表中的值? [英] How to quickly edit values in table in SQL Server Management Studio?

问题描述

除了上下文菜单 -> 对象资源管理器中的编辑前 200 行"之外，是否有一种快速方法可以在编辑模式下打开表格，我可以在其中快速修改单元格的值?

Aside from context menu -> "Edit Top 200 Rows" from Object Explorer, is there a quick way to open a table in Edit mode where I can just quickly modify the value of a cell?

我需要能够翻过前 200 行.而且我不想为我需要做的每一个小调整编写插入"脚本......我不明白为什么 SMS 不提供对分页表编辑器(如 Navicat)的快速访问.

I need to be able to page past the first 200 rows. And I dont want to write "insert" script for every minor tweak I need to do... I don't understand why SMS doesn't offer quick access to a paged table editor (like Navicat).

推荐答案

在 Mgmt Studio 中，当您编辑前 200 个时，您可以查看 SQL 窗格 - 通过右键单击网格并选择 Pane->SQL 或通过左上角的按钮.这将允许您编写自定义查询以深入到要编辑的行.

In Mgmt Studio, when you are editing the top 200, you can view the SQL pane - either by right clicking in the grid and choosing Pane->SQL or by the button in the upper left. This will allow you to write a custom query to drill down to the row(s) you want to edit.

但最终 mgmt studio 不是数据输入/更新工具，这就是为什么这有点麻烦.

But ultimately mgmt studio isn't a data entry/update tool which is why this is a little cumbersome.

这篇关于如何在 SQL Server Management Studio 中快速编辑表中的值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！