SQL Prompt 10 Snippets change

• 
  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    ##
  
  */
  

  cjbowman69 April 01, 2021 10:20

  - 0 +
• 
  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 July 29, 2021 14:52

  - 0 +
• 
  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 July 30, 2021 08:37

  - 0 +
• 
  <?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 April 15, 2022 00:59

  - 0 +
• 
  <?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 April 15, 2022 01:01

  - 0 +
• 
  <?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 April 15, 2022 01:01

  - 0 +
• 
  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.

  erici April 15, 2022 01:10

  - 0 +

Add comment

Please sign in to leave a comment.