XML-XSL Transformations in SQL Server

Question

XML-XSL Transformations in SQL Server

Cem Guler

SSC Journeyman

Points: 84
More actions
January 3, 2012 at 11:26 pm

#262350

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

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

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

David McKinney SSChampion Points: 10472 More actions · Answer 1

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.

ffoerster Right there with Babe Points: 796 More actions · Answer 2

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

Cem Guler SSC Journeyman Points: 84 More actions · Answer 3

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!