In SSMS I would like to use shortcuts for code snippets, just like in Visual Studio:
type 'shortcut'; hit TAB -> snippet expanded
In SSMS I need to CTRL+K, CTRL+X, mouse, mouse, find, go back, find, mouse. This is not a shortcut, nothing "short" about it.
I've added this sample snippet to my list of snippets:
<?xml version="1.0" encoding="utf-8"?>
<CodeSnippets xmlns="http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet">
<CodeSnippet Format="1.0.0">
<Header>
<Title>Transaction</Title>
<Author />
<Description>Transaction wrapper</Description>
<HelpUrl />
<SnippetTypes />
<Keywords />
<Shortcut>tra</Shortcut>
</Header>
<Snippet>
<References />
<Imports />
<Declarations>
<Literal Editable="true">
<ID>TSQL</ID>
<Type />
<ToolTip />
<Default>TSQL</Default>
<Function />
</Literal>
</Declarations>
<Code Language="SQL"><![CDATA[
BEGIN TRANSACTION TRAN1
$TSQL$
ROLLBACK TRANSACTION TRAN1]]>
</Code>
</Snippet>
</CodeSnippet>
</CodeSnippets>
I can find it via CTRL+K, CTRL+X, but I'm unable to invoke it by tra
+ TAB shortcut. Am I missing something? Can SSMS even do this?
I'm using SSMS v13.0.16100.1, but database is SQL Server 2014.