问题描述
除了上下文菜单 -> 对象资源管理器中的编辑前 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 中快速编辑表中的值?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!