XQuery: SQL type 'xml' is not supported in XQuery.
Got this error today:
XQuery: SQL type 'xml' is not supported in XQuery.
Trying to use sql:variable() inside a .modify DML call. I found a couple people having the same problem, and this soultion: http://blogs.msdn.com/denisruc/archive/2006/05/17/600250.aspx
Basically, you can't insert XML into XML - which is VERY frustrating. You can update values and attributes and elements, but not insert a new node. I might just implment the call inside a CLR sproc and load up the DOM.
It's little things like this that make the SQL2005 XML funcrtionality more "blah" than "wonderful."
M@
XQuery: SQL type 'xml' is not supported in XQuery.
Trying to use sql:variable() inside a .modify DML call. I found a couple people having the same problem, and this soultion: http://blogs.msdn.com/denisruc/archive/2006/05/17/600250.aspx
Basically, you can't insert XML into XML - which is VERY frustrating. You can update values and attributes and elements, but not insert a new node. I might just implment the call inside a CLR sproc and load up the DOM.
It's little things like this that make the SQL2005 XML funcrtionality more "blah" than "wonderful."
M@
posted by M@ at 11:19 AM
0 Comments:
Post a Comment
<< Home