SSMS Snippets and Labels

Question

I am using SSMS 2014. I can insert a fragment, but they do not seem to respond to shortcuts (ie crproc [tab])

Is this feature known to work?

<?xml version="1.0" encoding="utf-8" ?> <CodeSnippets xmlns="http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet"> <CodeSnippet Format="1.0.0"> <Header> <Title>prod1</Title> <Description>testing</Description> <Author> dale </Author> <SnippetTypes> <SnippetType>Expansion</SnippetType> </SnippetTypes> <Shortcut>crproc</Shortcut> </Header> <Snippet> <Declarations> <Literal> <ID>DatabaseName</ID> <ToolTip>Name of database.</ToolTip> <Default>DB</Default> </Literal> </Declarations> <Code Language="SQL"> <![CDATA[ ------------------------------------------------------ -- FILENAME: Template-Expansion.snippet -- PURPOSE: Template for Expansion (Insert) snippets. -- AUTHOR: Ken O. Bonn -- DATE: May 15, 2013 ------------------------------------------------------ SET NOCOUNT ON; EXEC SP_HELPDB $DatabaseName$; ]]> </Code> </Snippet> </CodeSnippet> </CodeSnippets> 

Answer 1

No, for some reason, Microsoft does not seem to be interested in actually implementing this function, despite the fact that the code fragments are absolutely useless without it (due to the number of mouse clicks and keystrokes you need to insert a fragment).

How many times a day do you enter "SELECT * FROM ..." or "SELECT TOP 10 * FROM" ... etc ??! Very frustrating!

Even the SSMS 2016 release candidate still does not support it.

ApexSQL Complete (a free tool) will apparently do this, but it does not yet support SSMS 2016!

Answer 2

Do not worry about specifying a specific label.
Just add it to my excerpts folder.

Be sure to save as .snippet

Press Ctrl + K, Ctrl + S
down arrow to my fragments enter
down arrow to the fragment you want to enter

your snippet will be surrounded by the code you like.

Answer 3

In ApexSQL Complete you have the opportunity to do this and, of course, support SSMS 2016 and even the new SSMS 17 RC, except that it is completely free

Answer 4

Add your snippet to the Features folder, where other SurroundsWith snippets are found. Then press CTRL + K, CTRL + S (shortcut for SurroundsWith Snippets) and enter a few letters from your fragment name and press enter. If only the Functions folder has SurroundsWith snippets, other folders are not displayed in other contexts in the context menu. Otherwise, you can enter several letters from the corresponding folder name and click the tab. This process is very similar to this answer.

Begin, If, and While fragments were found in my environment:

C: \ Program Files (x86) \ Microsoft SQL Server \ 130 \ Tools \ Binn \ ManagementStudio \ SQL \ Excerpts \ 1033 \ Function

Here is an example snippet for SELECT * FROM:

 <?xml version="1.0" encoding="utf-8" ?> <CodeSnippets xmlns="http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet"> <CodeSnippet Format="1.0.0"> <Header> <Title>Select</Title> <Shortcut>sel</Shortcut> <Description>SELECT * FROM _ WHERE 1=1 AND</Description> <Author/> <SnippetTypes> <SnippetType>SurroundsWith</SnippetType> </SnippetTypes> </Header> <Snippet> <Code Language="SQL"> <![CDATA[ SELECT * FROM dbo.$selected$$end$ WHERE 1=1 --AND ]]> </Code> </Snippet> </CodeSnippet> </CodeSnippets>