posted by ' at 16:34
You mean you could write the following simple expression with XML:SELECT (SELECT * FROM Customers FOR XML AUTO, ELEMENTS, TYPE).query( 'for $c in /Customers return <Customers>{ for $p in $c/* order by local-name($p) return $p }</Customers>'):-)
No.I really suck at XQuery, so meaning that is out of my range.This was so nice, I gave it a new post, hope you don't mind."SQL XML (Re: SQL cursors: This was a funny one)"
I have no problem with moving it into a new post. I am glad to be of help.
<< Home
View my complete profile
3 Comments:
You mean you could write the following simple expression with XML:
SELECT (SELECT * FROM Customers FOR XML AUTO, ELEMENTS, TYPE).query(
'for $c in /Customers
return
<Customers>{
for $p in $c/*
order by local-name($p)
return $p
}</Customers>'
)
:-)
No.
I really suck at XQuery, so meaning that is out of my range.
This was so nice, I gave it a new post, hope you don't mind.
"SQL XML (Re: SQL cursors: This was a funny one)"
I have no problem with moving it into a new post. I am glad to be of help.
Post a Comment
<< Home