Bloggurat
          rss       feed       personal mail       professional mail       msn       facebook       linkedin        

Saturday, October 29, 2005

SQL cursors: This was a funny one

Moved:
http://information-management-enabled.blogspot.com/2005/10/sql-cursors-this-was-funny-one.html

3 Comments:

Anonymous Michael Rys said...

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>'
)

:-)

9:01 AM, November 02, 2005  
Blogger gorm_norway said...

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)"

12:20 PM, November 02, 2005  
Anonymous Michael Rys said...

I have no problem with moving it into a new post. I am glad to be of help.

6:18 AM, November 04, 2005  

Post a Comment

Links to this post:

Create a Link

<< Home