SQL Server 2005/2008 - 双击打开表/查看前200个结果？ [英] SQL Server 2005/2008 - Double Click to open table / view first 200 results?

问题描述

有一种方法可以在SQL Server 2005/2008中按照标题来配置快捷方式等。

Is there a way to configure the shortcuts etc in SQL Server 2005 / 2008 as per the headline.

当我双击一个表时，我通常想打开它可以查看其中的信息，而不仅仅是访问资源管理器中的下一级。当我对一个过程这样做，我通常想要修改它。这个问题是一年过期，因为这个问题困扰了我很长一段时间。

When I doubleclick on a table, I typically want to open it to view the information within, not to just access the next level on the explorer. When I do this on a procedure, I usually want to modify it. This question is one year overdue as this issue has bothered me for quite some time.

有没有办法改变对这些项目的doubleclick的行动？它不到1％的时间，我实际上有一个用于doubleclick - >上升1级探索器功能。这对我来说似乎对所述程序的可用性不必要的不​​便。 ：）

Is there a way to change the action for a doubleclick on these items? It's less than 1% of the time when I actually have a use for the doubleclick -> go up 1 level on explorer functionality. Which to me seems like an unnecessary inconvenience in the usability of said program. :)

感谢。

推荐答案

您想要的结果相同：

1. 安装 SSMS工具包


2. 在SSMS中，转到SSMS工具菜单>运行自定义脚本>选项


3. 添加新的自定义脚本前200行，并添加以下Sql脚本：

1. Install SSMS Tools Pack
2. In SSMS, go to the SSMS Tools menu > Run Custom Stripts > Options

3. Add a new custom script "Top 200 rows", and add the following Sql script:

SELECT TOP 200 * FROM | NodeName |

SELECT TOP 200 * FROM |NodeName|

点击已启用...，然后选择表格

Click "Enabled on..." and select "Table"

这篇关于SQL Server 2005/2008 - 双击打开表/查看前200个结果？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！