SQL SERVER 2014代码段丢失 [英] SQL SERVER 2014 Code Snippets missing
问题描述
我正在尝试在SQL Server中使用摘要功能。
I'm trying to use the Snippets functionality in SQL Server.
我正在测试按照此处。
一切正常,除了我添加了代码段之后,它没有出现在IntelliSense中。更重要的是,我意识到并不是所有内置片段都出现了。
Everything works fine except that after I added the snippet, it doesn't show up in the IntelliSense. Even more, I realized that not all build-in Snippets are showing up.
我想知道是否还有其他人具有相同的经验,并且知道如何解决这个问题?
I wonder if anyone else has the same experience, and knows how to resolve this?
这是一个功能
这就是我从IntelliSense中看到的内容(其中3个丢失了)
And this is what I see from IntelliSense (3 of them are missing)
推荐答案
问题可能与代码段的定义有关。
The issue is likely in the definition of the snippets.
如果您检查代码段,应该看到类似:
If you inspect your snippets you should see a section like:
<SnippetTypes>
<SnippetType>SurroundsWith</SnippetType>
</SnippetTypes>
或
<SnippetTypes>
<SnippetType>Expansion</SnippetType>
</SnippetTypes>
这些指示代码段的位置和使用位置。
These indicate where the snippet can and will be used from.
在查询窗口中,右键单击时有两个选项:
In a query window you have 2 options when you right click:
- 插入摘要
- 与 一起环绕
- Insert snippet
- Surround with
为您提供不同的选择,如您在此处看到的那样:
Which give you the different options as you can see here:
这说明了为什么在尝试插入代码片段时看不到缺少的选项。
This explains why you're not seeing the missing options when you try to insert a snippet.
这篇关于SQL SERVER 2014代码段丢失的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!