What are the challenges you face when working across database platforms? Take the survey
Options

SQL Prompt 10 Snippets change

AaronPDXAaronPDX Posts: 3 New member
edited January 14, 2020 8:42PM in SQL Prompt
"Removed built-in snippets 'j', 'neo' and 'yell'."

Booooooooooooooooooooooooooooooooooooooooooooo.

How do I rollback to 9.5?

Comments

  • Options
    cjbowman69cjbowman69 Posts: 2 New member
    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    ##

    */
  • Options
    gnbfilhognbfilho Posts: 5 New member
    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.
  • Options
    gnbfilhognbfilho Posts: 5 New member
    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.
  • Options
    ericierici Posts: 4 New member
    <?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>
  • Options
    ericierici Posts: 4 New member
    <?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>
  • Options
    ericierici Posts: 4 New member
    <?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>
  • Options
    ericierici Posts: 4 New member
    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.
Sign In or Register to comment.