Using Code Snippets in SSMS

• gbritton1

  SSCertifiable

  Points: 6522

  More actions

  August 21, 2018 at 11:03 am

  #2002721

  Luis Cazares - Wednesday, April 6, 2016 11:36 PM

  Comments posted to this topic are about the item Using Code Snippets in SSMS

  Wow, followed all the steps, I think. but SSMS doesn't see my custom snippets.

• mtrudel337

  SSC Rookie

  Points: 33

  More actions

  April 11, 2020 at 2:42 pm

  #3742209

  Hi

  Anyway to create a surround snippet  for a SQL function like SUM(), CONVERT(), ISNULL() with AS Field at the end

  SUM(MyField) AS MyField ?

  It is not possible to include $selected$ twice in a snippet code as in:

  Code Language="SQL"><![CDATA[SUM($selected) AS $selected$]]>

  Do you know another way ?

  I tried many SSMS addons. None is able to do this

   

   

• Steve Collins

  SSCrazy

  Points: 2190

  More actions

  April 11, 2020 at 3:19 pm

  #3742211

  This is great article!  I'm going to give it a try.

  Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  April 13, 2020 at 4:28 pm

  #3742462

  mtrudel337 wrote:

  Hi

  Anyway to create a surround snippet  for a SQL function like SUM(), CONVERT(), ISNULL() with AS Field at the end

  SUM(MyField) AS MyField ?

  It is not possible to include $selected$ twice in a snippet code as in:

  Code Language="SQL"><![CDATA[SUM($selected) AS $selected$]]>

  Do you know another way ?

  I tried many SSMS addons. None is able to do this

   

  There's an alternative with an extra step that might work a few comments back.

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2

• jonathan.crawford

  SSCertifiable

  Points: 6613

  More actions

  April 13, 2020 at 4:54 pm

  #3742473

  Yeah, I think Luis' suggestion of making it an expansion template is the way to go. There may be a way to make it work using XSLT, but that seems like overkill, and I'm not sure it's really any easier.

  I tried declaring a variable and populating it with the $selected$ value, but it still won't work. Doesn't recognize the placeholder in the Declarations, even if I use the CDATA tags, and only drops the value in as a replaceable field instead of actually putting the value in.

  -------------------------------------------------------------------------------------------------------------------------------------
  Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses