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

XML Workshop V - Reading Values from XML Columns Expand / Collapse
Author
Message
Posted Monday, July 16, 2007 5:17 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/3117.asp

.
Post #382147
Posted Thursday, August 23, 2007 12:57 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, July 08, 2009 2:37 PM
Points: 194, Visits: 3

This workshop is really very helpful. I had no idea that how to read the xml stuff through query but now I am very much clear about it.

Is there any way to directly read from any xml file ?

or

Every time when there is a need to read xml stuff just load all the stuff in particular column then read it.

Any comments regarding my question will be appreciated.

thanks in advance

Post #393437
Posted Friday, August 24, 2007 12:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 13, 2010 11:00 PM
Points: 1, Visits: 8
This workshop is very informative for me. I had read about XPath and using MSXML2.DOMDocument.4.0 object to read and XML File, but now I get data direct from DB.
Thanks.

Dear Shahzad, you can use "MSXML2.DOMDocument.4.0" for reading direct from any XML File, but you have to read about XPath before using this object

Asif Mehar
Post #393567
Posted Friday, August 24, 2007 1:04 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

There is an execellent article by Robyn Page and Phil Factor at http://www.simple-talk.com/sql/t-sql-programming/rss-newsfeed-workbench/

The above article shows how to read a disk file using OPENROWSET + BULK

 



.
Post #393569
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse