blocks|key|1389404|text|此功能似乎不存在。它已被推荐给Microsoft。我建议投票支持它；http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=368542|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1389405|作为一种解决办法，我使用Notepad%2B%2B在本地进行编辑。它的区域识别能力不是很好，但总比没有强。|1389406|entityMap|0|LINK|mutability|MUTABLE|url|http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=368542^0|Y|2B|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

It appears this feature does not exist. It has been recommended to Microsoft. I suggest voting it up;
<a href="http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=368542" rel="noreferrer">http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=368542</a>

As a work-around, I'm using Notepad++ to edit locally. Its region identification isn't as good, but it's better than nothing.

blocks|key|1174113|text|这不是快捷键，但在查询编辑器中有一个菜单选项可以执行此操作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1174114|打开您的查询，然后转到编辑>大纲>切换所有大纲。|1174115|这将切换(即展开/折叠)查询中的所有节点。|1174116|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

This isn't a shortcut key, but there is a menu option in the Query Editor to do this.

Open your query and then go to Edit > Outlining > Toggle All Outlining.

This will toggle (i.e. expand/collapse) all nodes in the query.

blocks|key|1173918|text|解决方法是使用BEGIN和END。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1173919|BEGIN+--+comment+on/explain+the+region/outlined+section

/*

TSQL+goes+here

*/

END|code-block|syntax|javascript|1173920|然后，您将能够折叠开始。|1173921|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

A workaround is to use BEGIN and END.

<pre><code>BEGIN -- comment on/explain the region/outlined section

/*

TSQL goes here

*/

END
</code></pre>

You will then be able to collapse the BEGIN.

blocks|key|1389869|text|在ssms+2017+->中，工具>选项中有一个选项{见图}|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1389870|下面是@Triynko对@Shawns答案的更新|1389871|​|1389872|📷|atomic|offset|length|1389873|1389874|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/92159b7a775d63ac520f2cf3078872ad.png|imageAlt^0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@$I|Y|J|Z|1|10]]|A|$]]|$1|K|3|E|5|6|7|11|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S|T|-4]]]]

In ssms 2017 -> There is an option in Tools > Options {see image}

The below illustrates @Triynko update to @Shawns answer

<a href="https://i.stack.imgur.com/ijjj4.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ijjj4.png" alt="enter image description here"></a>

blocks|key|1173956|text|SSMS有一个免费的第三方插件，叫做SSMS工具包。它提供了几个有用的功能，包括可折叠区域和调试节。默认情况下，当您第一次打开.sql脚本时，区域会折叠。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1173957|http://www.ssmstoolspack.com/Features?f=9|offset|length|1173958|例如：|1173959|--#region+You+can+place+comments+here+which+are+visible+when+the+region+is+collapsed.

if+object_id('MyTable')+is+null
begin
+++create+table+MyTable+
+++(
+++constraint+[pk_mytable]+primary+key+clustered+(+mytable_id+),
+++mytable_id+int+not+null++
+++);
end;

--#endregion|code-block|syntax|javascript|1173960|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|15|0|0|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@]|9|@$D|V|E|W|1|X]]|A|$]]|$1|F|3|G|5|6|7|Y|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|Z|8|@]|9|@]|A|$K|L]]|$1|M|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|C]]]]

There is a free 3rd party add-in for SSMS called, SSMS Tools Pack. It provides several useful features, which includes collapsable regions and debug sections. By default, the regions are collapsed when you first open a .sql script.

<a href="http://www.ssmstoolspack.com/Features?f=9" rel="nofollow">http://www.ssmstoolspack.com/Features?f=9</a>

For example:

<pre><code>--#region You can place comments here which are visible when the region is collapsed.

if object_id('MyTable') is null
begin
 create table MyTable 
 (
 constraint [pk_mytable] primary key clustered ( mytable_id ),
 mytable_id int not null 
 );
end;

--#endregion
</code></pre>

blocks|key|1389651|text|如果您在Visual+Studio中打开一个.sql脚本，那么您可以折叠其中的代码。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1389652|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If you open a .sql script in Visual Studio then you can collapse the code in there.

blocks|key|1174434|text|在我的条件下，它是“最大脚本大小”默认是1MB，我的是1Mb以上，将其更改为5MB，它可以工作|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1174435|路径是|1174436|工具>>选项>>文本编辑器>>+TransactSQL+>>智能感知>>最大脚本大小|1174437|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

In my condition it was "Maximun Script Size" default is 1MB, mine was above 1Mb changed it to 5MB it works 

Path is 

Tools >> Options >> Text Editor >> TransactSQL >> Intellisense >> Maximum Script Size

blocks|key|1174186|text|Ctrl%2BM、Ctrl%2BA是SSMS+17.X中的默认值。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1174187|您可以通过转到工具>选项>环境>键盘来更改此设置，然后单击命令Edit.CollapseAllOutlining并分配您的新快捷键。|1174188|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Ctrl+M,Ctrl+A is the default in SSMS 17.X.

You can change this by going to Tools > Options > Environment > Keyboard, then click on command Edit.CollapseAllOutlining and Assign your new shortcut keys.

blocks|key|1389615|text|此功能已在SQL+Server+Management+Studio2012中实现，并可用于其他版本，还可以使用CTRL+%2BM+etc+-+https://msdn.microsoft.com/en-us/library/ms174205(v=sql.110).aspx|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1389616|entityMap|0|LINK|mutability|MUTABLE|url|https://msdn.microsoft.com/en-us/library/ms174205(v=sql.110).aspx^0|1X|1T|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

This feature was implemented in SQL Server Management Studio 2012 and is available for editions beyond also using CTRL + M etc - <a href="https://msdn.microsoft.com/en-us/library/ms174205(v=sql.110).aspx" rel="nofollow">https://msdn.microsoft.com/en-us/library/ms174205(v=sql.110).aspx</a>

A new feature in SQL Server Management Studio 2008 is 'outlining' (the ability to collapse regions). It is awesome. However, by default all regions are expanded. I can't seem to find a way to 'collapse all' (also called 'toggle outline' in Visual Studio). Is anyone aware of a way to do this? I've been tasked with reviewing a 3,000 line stored procedure, and collapsing regions one-by-one is cumbersome.

"collapse all' or "toggle outline" in SQL Server Management Studio 2008

Visual Studio

SQL Server

SQL Server Management Studio2008中的一个新功能是“大纲”(折叠区域的能力)。这太棒了。但是，默认情况下，所有区域都会展开。我似乎找不到一种方法来“折叠所有”(在Visual Studio中也称为“切换轮廓”)。有没有人知道如何做到这一点？我的任务是检查一个3000行的存储过程，一个接一个地折叠区域是很麻烦的。

问SQL Server Management Studio 2008中的“全部折叠”或“切换大纲”
EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL Server Management Studio 2008中的“全部折叠”或“切换大纲”EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL Server Management Studio 2008中的“全部折叠”或“切换大纲”
EN