SQL Prompt 10 Snippets change

AaronPDX

"Removed built-in snippets 'j', 'neo' and 'yell'."

Booooooooooooooooooooooooooooooooooooooooooooo.

How do I rollback to 9.5?

cjbowman69

Hi @AaronPDX,
Good news, you can add it back in yourself!

1. On the SQL Prompt menu, select Snippet Manager.
2. Click New.
3. In the Snippet box, type the text that will insert the snippet.
4. Optionally, type a short description of your snippet in the Description box.
5. The description helps you to identify a snippet if you are unsure of the snippet name. You can leave the Description box blank if required.
6. Type or paste the SQL code in the Code box.

(The Spaces dont look right at time of writing but should work in SSMS)

Snippet: yell
Description: Vent your frustration
/*

 AAAA   AAAA   AAAA   AAAA  RRRR    GGGG  HH  HH  ######
AA  AA AA  AA AA  AA AA  AA RR  RR GG  GG HH  HH  ######
AA  AA AA  AA AA  AA AA  AA RR  RR GG     HH  HH   ####
AAAAAA AAAAAA AAAAAA AAAAAA RRRRR  GG GGG HHHHHH    ##
AA  AA AA  AA AA  AA AA  AA RR  RR GG  GG HH  HH
AA  AA AA  AA AA  AA AA  AA RR  RR  GGG G HH  HH    ##

*/

gnbfilho

cjbowman69! Tks a lot!

Do you have the code for the 'neo' snippet?

It's a pity not having these snippets in the newer versions. I really miss them. They used to give personality to SQL Prompt.

gnbfilho

cjbowman69! Tks a lot!

Do you have the code for the 'neo' snippet?

It's a pity not having these snippets in the newer versions. I really miss them. They used to give personality to SQL Prompt.

erici

<?xml version="1.0" encoding="utf-8"?>

<CodeSnippets>

  <CodeSnippet Format="1.0.0">

    <Header>

      <Title>neo</Title>

      <Shortcut>neo</Shortcut>

      <Description>A word from one of our sponsors</Description>

      <Author />

      <SnippetTypes>

        <SnippetType>Expansion</SnippetType>

      </SnippetTypes>

    </Header>

    <Snippet>

      <Declarations />

      <Code Language="sql"><![CDATA[-- I know Kung-Fu.]]></Code>

    </Snippet>

  </CodeSnippet>

</CodeSnippets>

erici

<?xml version="1.0" encoding="utf-8"?>

<CodeSnippets>

  <CodeSnippet Format="1.0.0">

    <Header>

      <Title>yell</Title>

      <Shortcut>yell</Shortcut>

      <Description>Vent your frustration</Description>

      <Author />

      <SnippetTypes>

        <SnippetType>Expansion</SnippetType>

      </SnippetTypes>

    </Header>

    <Snippet>

      <Declarations />

      <Code Language="sql"><![CDATA[/*

  AAAA   AAAA   AAAA   AAAA  RRRRR   GGGG  HH  HH  ######

 AA  AA AA  AA AA  AA AA  AA RR  RR GG  GG HH  HH  ######

 AA  AA AA  AA AA  AA AA  AA RR  RR GG     HH  HH   ####

 AAAAAA AAAAAA AAAAAA AAAAAA RRRRR  GG GGG HHHHHH    ##

 AA  AA AA  AA AA  AA AA  AA RR  RR GG  GG HH  HH

 AA  AA AA  AA AA  AA AA  AA RR  RR  GGG G HH  HH    ##

*/]]></Code>

    </Snippet>

  </CodeSnippet>

</CodeSnippets>

erici

<?xml version="1.0" encoding="utf-8"?>

<CodeSnippets>

  <CodeSnippet Format="1.0.0">

    <Header>

      <Title>j</Title>

      <Shortcut>j</Shortcut>

      <Description>JOIN fragment</Description>

      <Author />

      <SnippetTypes>

        <SnippetType>Expansion</SnippetType>

      </SnippetTypes>

    </Header>

    <Snippet>

      <Declarations />

      <Code Language="sql"><![CDATA[JOIN ]]></Code>

    </Snippet>

  </CodeSnippet>

</CodeSnippets>

erici

SQL Prompt 10 uses JSON format instead of XML for the snippet files, so you'll want to either copy the text into the Snippet Manager or recreate the above using JSON, but note that the JSON uses a GUID in the file name and within the text of the Snippet file.  The GUIDs for both should match and be unique from other GUIDs for other snippets.