Using the “Replace” Function in Sql Server/T-SQL

I ran into an issue today where I needed to strip two characters out of a field while in a stored procedure.  The string looked something like this:

@UserID = {abcdefghi}

I needed the middle text (abcdefgi) only so I used the replace function.  The replace function only allows you to replace one thing at a time so I had to use it twice.  This is what the end result looks like:

replace(replace(@UserID,'{‘,”),’}’,”)

Ugly, yes, but it gets the job done.

 

How to count xml nodes using Freemarker

I looked all over the web today for a working example of how to count xml branches in the xml dom using Freemarker.  I finally came across the answer and thought I would share in case anyone else is looking for it.

Here is a sample from the XML:

  
  <asn>
    <Packages>
      <Package>
        <PackageID/>
      </Package>
      <Package>
        <PackageID/>
      </Package>
    </Packages>
  </asn>

Freemarker code:  ${asn.Packages.Package?size}

Output: 2