Tag: query()

Using XQuery to transform multiple xml nodes to a single xml node with comma separated string value
By Art on July 13, 2012

Not another comma separated string blog post I hear you say! I know that this topic has probably been done to death but I hope that this is a little different as it is about creating a single xml node containing a comma separated string from the values of multiple other xml nodes all within an XQuery expression. Recently I’ve […]

Read More
Moving xml child elements to its parent using XQuery
By Art on July 9, 2012

I haven’t been able to do much XQuery development recently which is a shame as I love developing with the technology in SQL. In the past I used to work with xslt’s a lot and they immensely powerful, but since moving to xquerying in SQL, it is now my first choice for quick xml transformations. Especially if the XML is […]

Read More
Tags
Admin Azure backup Blogging Bug C# Career CDC Certification Collations Command Line Comments Configuration Connect Consulting CU Cursor DBA DDL delete Disaster Recovery Disks DMV DR Execution Plans Facebook FIGlet FileTable Firewall Flwor Fun Hack Indexes Internals modify() Performance query() Script Service Broker SQL 2012 SQLBits SQLCLR Training Views VM Xml XML DML Xml Functions XPath XQuery
Categories
Uncategorised (61)