Post reply

XML-XSL Transformations in SQL Server

  • January 3, 2012 at 11:26 pm

    #262350

    Comments posted to this topic are about the item XML-XSL Transformations in SQL Server

  • January 4, 2012 at 2:54 am

    #1428148

    Thanks Cem, good to know. This 'data quality services' looks like one to watch. But it seems to me you could have achieved the same result as in your example by using a standard dot net xml assembly, rather than the new data services one.

    I think it's about time xsl transformations were added to the otherwise comprehensive set of xml features in sql server. There is often reluctance to add CLR assemblies to sql, and yet many of the sql xml features are nothing but wrappers for CLR functions....so why not add just one or two little xsl transformation functions out of the box. After all xsl is often a good method for reworking xml - and not only a method for producing html etc..

    Regards,

    David McKinney.

  • January 4, 2012 at 9:03 am

    #1428400

    Thanks for the article. 🙂 However, I am using Xsl transformations, Levenshtein, Regex Functions since SQL 2005 came out through my own CLR assembly. I would not migrate to MDS in my case.

    For people new to SQL 2008 R2 / MDS this might indeed be valuable to know .. as u said "why re-invent the wheel".

    Happy New Year

    Frank

  • January 4, 2012 at 9:13 am

    #1428412

    This article simply shows an alternative method to achieve xsl transformations without writing too much code. There is always the possibility to write your own CLR assembly or use another library to achieve the same results.

    Cheers!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply