Category Archives: XML

Searching for underscores with LIKE

Posted on January 14, 2022 by ph1lqu1nn

I got caught out by a Gotcha which has caught me out many times and hopefully wont again ( but it will). I was looking for a specific piece of text within a sql module in a Database, simple right! … Continue reading →

Posted in SQL, XML | Leave a comment

Recursive XML branches

Posted on August 19, 2013 by ph1lqu1nn

One of the main features of XML is that it handles hierarchical data structures.  I agree that so does SQL either using the hierarchy variable or creating a Recursive CTE.  but nothing compares to the simplicity  of the XML format … Continue reading →

Posted in Uncategorized, XML | Leave a comment

Enforcing XML Document Structure

Posted on November 16, 2012 by ph1lqu1nn

by default the xml variable supports a content structure of xml this is very useful if you are constructing an xml blob.  It works for typed and untyped code, and it has it’s place. The following code shows an xml … Continue reading →

Posted in XML, XML Schemas | Tagged , | Leave a comment

Schema visibility using xml_schema_namespace

Posted on November 1, 2012 by ph1lqu1nn

One of the issues I’ve faced is the constant referencing and rereferencing of XML Schemas that are stored against a database.  the xml_schema_namespace dmv helps with this.  it takes 2 parameters.  the schema of the database object XML Schema and … Continue reading →

Posted in SQL, XML, XML Schemas | Leave a comment

modifying data in XML a really clunky solution. (no I mean REALLY Clunky)

Posted on October 11, 2012 by ph1lqu1nn

If you are trying to replace the value of an element that does not exist if can be problematic, i have not found a nice way to do this, if any one does please let me know. So to get … Continue reading →

Posted in XML | 2 Comments

Schema validation using Reg Ex

Posted on September 20, 2012 by ph1lqu1nn

One of the most powerful tools that XML in SQL Server brings to the table is Regular expresions. In XML Schemas Regular Expressions are an easy method to validate your data without having to bolt on complex CLR functions to … Continue reading →

Posted in SQL, XML | Leave a comment

XML .value simple syntax

Posted on May 7, 2012 by ph1lqu1nn

There are several ways to get .value to extract an item of information from xml.  in the following article I will show some of the syntax and reasons why some methods are better than others. All the calls in this … Continue reading →

Posted in SQL, XML | Leave a comment