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»»»

Advanced XML Processing Expand / Collapse
Author
Message
Posted Wednesday, May 2, 2007 4:40 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
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jSebastian/2982.asp

.
Post #362813
Posted Tuesday, May 8, 2007 10:52 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Today @ 8:32 AM
Points: 9, Visits: 210
Excellent. Now we're cookin' with gas! Thanks.
Post #364265
Posted Wednesday, May 9, 2007 1:26 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, May 8, 2013 7:23 AM
Points: 199, Visits: 136

Nicely done... simple and easy language.

Keep it up!!!

Post #364297
Posted Wednesday, May 9, 2007 4:52 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, September 12, 2007 1:00 PM
Points: 48, Visits: 1
I found article very usefull. Thank you.


Post #364314
Posted Wednesday, May 9, 2007 5:06 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 30, 2014 9:48 AM
Points: 22, Visits: 38
great article! I never realised how simple it actually is to get XML out of 2005.
Post #364316
Posted Wednesday, May 9, 2007 5:59 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: Saturday, September 10, 2011 8:08 AM
Points: 539, Visits: 201
I agree, that was a great article.  Very simple and very worthwhile.
Post #364323
Posted Wednesday, May 9, 2007 6:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 8, 2010 2:17 PM
Points: 1, Visits: 3
Very helpful, thanks. If you have xml already in an nvarchar column, is there any way to have it not be escaped in the for xml output? I'm thinking I might be able to write a query that would insert that nvarchar column into a temp table with an xml datatype. Then I would be able to query inside the xml document itself while joining with other data. Right now we are stuck with LIKE queries.
Post #364339
Posted Wednesday, May 9, 2007 7:12 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, May 29, 2012 11:22 AM
Points: 1,755, Visits: 4,652

Very nicely-presented article - well done Jacob!

My only suggestion would be to rename this particular article to 'Simple XML Processing', as some people might be unnecessarily scared off 

I look forward to the next article...




Ryan Randall

Solutions are easy. Understanding the problem, now, that's the hard part.
Post #364342
Posted Wednesday, May 9, 2007 7:40 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, June 25, 2009 6:14 AM
Points: 876, Visits: 78
Thanks! I needed That

Artificial Intelligence stands no chance against Natural Stupidity.
Post #364357
Posted Wednesday, May 9, 2007 8:02 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, November 21, 2014 6:34 AM
Points: 6,259, Visits: 2,031
Great Article! Simple through examples and very clear.
Keep'em comming

Cheers,



* Noel
Post #364374
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse