如何编程键盘快捷方式以从所选表中选择前1000 *个? [英] How can I program a keyboard shortcut to select top 1000* from selected table?

问题描述

是否可以在ssms 2012中创建键盘快捷键，使其在按下时与select top 1000 * from mytable具有相同的作用?

Is there a way to create a keyboard shortcut in ssms 2012 that when pressed will have the same effect as select top 1000 * from mytable ?

我已经对此进行了探索: http://msdn.microsoft.com/zh-我们/library/ms174178 .

I have explored this already: http://msdn.microsoft.com/en-us/library/ms174178.

通常，当经常浏览数据库时，程序员需要从表中选择顶部记录.

Often times when exploring a database very frequently the programmer needs to select top records from tables.

如果无法在ssms中自定义，我将对C#解决方案感到满意，

If this is not customizable in ssms, I would be happy with a c# solution,

推荐答案

工具->选项，然后环境->键盘->查询快捷方式.将密钥分配为:

Tools -> Options, then Environment -> Keyboard -> Query Shortcuts. Assign a key to be:

select top 1000 * from 

请注意没有表名.现在按确定，并打开一个新的查询窗口.突出显示一个表名，然后按组合键.

Notice no table name. Now press OK, and open a new query window. Highlight a table name and then hit your key combo.

这篇关于如何编程键盘快捷方式以从所选表中选择前1000 *个?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！