SQL Server 2008 中的 Open Table 何去何从？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/358382/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Where did Open Table go in SQL Server 2008?
提问by John Dunagan
As of SQL Server 2005, you used to be able to open a flat file in SQL Management Studio off the right click menu for any database table. Once opened, you could add or update records right there in the grid.
从 SQL Server 2005 开始，您过去可以在 SQL Management Studio 中打开任何数据库表的右键单击菜单中的平面文件。打开后，您可以直接在网格中添加或更新记录。
Now that SQL Server 2008 is out, Microsoft has hidden that feature, at least from the right-click menu.
现在 SQL Server 2008 已经出来了，微软已经隐藏了这个功能，至少在右键菜单中是这样。
Where did it go?
它去了哪里？
回答by Nicholas Piasecki
It's replaced by "Edit Top 200 Rows". You can change that command in the Tools > Options > SQL Server Object Explorer > Commands.
它被“编辑前 200 行”取代。您可以在工具 > 选项 > SQL Server 对象资源管理器 > 命令中更改该命令。
But once you right-click a table, choose "Edit Top 200 Rows", hunt on the toolbar for a button called "Show SQL Pane". From here you can edit the query so the grid shows a subset of the data that you want.
但是一旦你右键单击一个表，选择“编辑前 200 行”，在工具栏上寻找一个名为“显示 SQL 窗格”的按钮。从这里您可以编辑查询，以便网格显示您想要的数据子集。
They did this because people were accidentally opening huge tables with the old Open Table command. This method seems to work pretty well, though in general I find that the 2008 version is pretty wonky when talking to 2005 databases, but that's another matter....
他们这样做是因为人们不小心使用旧的 Open Table 命令打开了大桌子。这种方法似乎工作得很好，虽然总的来说我发现 2008 版本在与 2005 数据库交谈时非常不稳定，但那是另一回事......
回答by John Dunagan
Changed the value in options to 0 and you can open the entire table.
将选项中的值更改为 0，您可以打开整个表。
回答by kl?na
You could sett the default value of "Edit Top 200 Rows" too "0"
您也可以将“编辑前 200 行”的默认值设置为“0”
In the Tools Menu -> Options... under SQL server Object Explorer\Table and view options\Value Edit Top Rows Command. Change the default value 200 too "0".
在工具菜单 -> 选项...下 SQL 服务器对象资源管理器\表和查看选项\值编辑顶行命令。将默认值 200 也更改为“0”。
You should now have the option "Edit All Rows" instead of "Edit Top 200 Rows" as a default and if you know it is a laaarge table use the "Select Top 1000 Rows" as a rewiew of the table.
您现在应该有选项“编辑所有行”而不是“编辑前 200 行”作为默认选项，如果您知道它是一个 laaarge 表，请使用“选择前 1000 行”作为表的重新查看。
