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|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|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|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>

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|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|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|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|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

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

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

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

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

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

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

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