Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

XML Workshop - FOR XML PATH Expand / Collapse
Author
Message
Posted Tuesday, May 22, 2007 10:55 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:42 AM
Points: 460, Visits: 2,523
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jSebastian/3022.asp

.
Post #368012
Posted Tuesday, June 19, 2007 10:33 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 14, 2014 1:14 PM
Points: 1, Visits: 33
I like this. Very cool and useful.
Post #375150
Posted Wednesday, June 20, 2007 12:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 3, 2007 2:46 AM
Points: 1, Visits: 1
Very very informative and good material for explanation..
Very good
Post #375163
Posted Wednesday, June 20, 2007 1:03 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 9:09 AM
Points: 645, Visits: 1,844

Hi,

Nice article.

At one stage you say that auto mode does not allow you to specify a root element, and you provide a work around.  Are you perhaps talking about SQL 2000?  As by using the following construct with SQL 2005, you can very simply provide a root element.

FOR XML AUTO, ROOT ('CustomersByRegion')

Regards,

David McKinney.

Post #375167
Posted Wednesday, June 20, 2007 1:19 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:42 AM
Points: 460, Visits: 2,523

Hi David,

You are right. Thakx for pointing this.

Jacob



.
Post #375170
Posted Wednesday, June 20, 2007 2:53 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 11:08 AM
Points: 577, Visits: 2,502

This is very useful, Jacob, and nicely explained. Thanks for that. I loved the format. I find PATH the most intuitive way of generating XML to a precise format. I really struggled before I started using it.

p.s. microsoft.public.sqlserver.xml can be really useful for  people like me who are still slightly mystified by aspects of XML.




Best wishes,

Phil Factor
Simple Talk
Post #375191
Posted Wednesday, June 20, 2007 3:07 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:42 AM
Points: 460, Visits: 2,523

Hi phil,

Thank you for the comments. I am a regular reader of your articles at simple-talk. They are simply excellent .

regards

Jacob



.
Post #375194
Posted Wednesday, June 20, 2007 3:07 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, October 21, 2011 12:17 PM
Points: 103, Visits: 158
I think PATH is really a great alternative to doing some simple nesting versus EXPLICIT. I'd like to see an article on PATH vs EXPLICIT to see where PATH can be used to supplant EXPLICIT. Good article.
Post #375433
Posted Wednesday, June 20, 2007 11:53 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:42 AM
Points: 460, Visits: 2,523

Hi charles,

There is an article on EXPLICIT already on the way. It may be appearing in the next few weeks.

thankx

Jacob



.
Post #375469
Posted Thursday, September 20, 2007 3:15 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, March 17, 2014 8:51 AM
Points: 42, Visits: 104
This is very good information. One other thing I often need, though is to supply namespace declarations in the root or other nodes. How would you add these? I noticed the XSINIL parameter on ELEMENTS adds an XMLSchema-instance namespace.
Post #400959
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse