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 Expand / Collapse
Author
Message
Posted Monday, August 2, 2010 6:13 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Tuesday, November 13, 2012 3:17 AM
Points: 133, Visits: 244
Im developing a system that reads XML from a database. I need to get XML into the xml column of my table for testing. I only need a handful of rows in the table for testing purposes so Im manually inserting them from within management studio. How can I get XML into the XML column in the table ? With most other column types I can paste stuff in directly, but with the xml column it doesnt seem to work. I have several xml files, I just want to take the xml out of the file and put it into its column in the table. Is there an easy way to do this ? I dont want to have to create some sort of custom app just to get some test data into the table.
Post #962113
Posted Monday, August 2, 2010 7:40 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, July 28, 2014 11:14 AM
Points: 1,618, Visits: 20,979
This article explains it better.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Post #962193
Posted Monday, August 2, 2010 7:54 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Tuesday, November 13, 2012 3:17 AM
Points: 133, Visits: 244
that seems to relate to partitioned indexes
Post #962205
Posted Monday, August 2, 2010 7:59 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Tuesday, November 13, 2012 3:17 AM
Points: 133, Visits: 244
ive managed to sort it anway, thanks
Post #962210
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse