You know that when you INSERT or UPDATE in a XML type field of table, SQL
Server deletes the CDATA et encode the section with HTML characters.
exemple :
CREATE TABLE #test ( xmldata xml )

I have a table with 2 XML type columns of the same structure. How do I
compare these 2 columns and return the difference? For example, here are some
sample data in the two xml columns:
xmlcol1                      xmlcol2

Is it possible to change an attribute value using XQuery?  I
understand how to use "modify" to change an Element value, but can you
change an Attribute value?
For example, let's say I have the following:

How do I add <?xml version="1.0" encoding="UTF-8"?> to the first line of the
output from this query?
select 1 as TAG, NULL as Parent, xx as [variable!1!name], yy as
[variable!1!!element] FROM zz for XML EXPLICIT, ROOT('test')

I want my result set to include the "<" character within the node
element name however the sql compiler is returning an invalid
character err. msg. ("..contains an invalid XML identifier as required
by FOR XML; '''(0x0027) is the first character at fault.").  I've

I am new to SQLXML and have found the tutorial for importing using an
XDR schema.  The problem I am having is that my xml file has nested
elements, and I cannot figure out how to get the process to pull them
in.  I have found examples using attributes, but none using

I am converting thousands of XML files to a SQL Server 2005 Database.
Everything goes fine, until I run into a section of mal-formed XML. In
passing the XML section to the stored procedure for inserting it into the
Section table, I receive the following error: "XML parsing: line 1 ...

I'm new to XML and need to implement the IODEF XML Schema (http://
staff.science.uva.nl/~demch/projects/iodef/index.html) in SQL 2005.
I downloaded the latest schema (http://staff.science.uva.nl/~demch/
projects/iodef/draft-ietf-inch-iodef-044.xsd) and attempted to load

Dear SQL Server XML experts,
I have a problem with using the WITH XMLNAMESPACES clause within a
function. This function shall return an XML fragment that will later
be used in a SELECT statement. I need to add a default namespace to