Clever Geek Handbook

Invalid SQL SERVER 2014 Code Snippets

I am trying to use the Snippets functionality in SQL Server.

I am testing adding new snippets to SQL Server 2014 following the instructions here .

Everything works fine, except that after adding a snippet, it doesn't show up in IntelliSense. Moreover, I realized that not all inline fragments appear.

I wonder if anyone else has experience and knows how to solve this?

This is a list of inline snippets in Function

build-in

And this is what I see from IntelliSense (3 of them are missing)

missing snippet

+3


source to share


1 answer


The problem is probably related to the definition of the fragments.

If you check your snippets you will see a section like:

<SnippetTypes>
    <SnippetType>SurroundsWith</SnippetType>
</SnippetTypes>

Or

<SnippetTypes>
    <SnippetType>Expansion</SnippetType>
</SnippetTypes>

They indicate where this piece can and will be used.



In the query window, you have 2 options when you right click:

  • Insert snippet
  • Surround with

Which gives you different options, which you can see here:

enter image description here

enter image description here

This explains why you don't see the missing parameters when you try to insert a snippet.

+5


source






More articles:


All Articles