August 2, 2010 at 6:13 am
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.
August 2, 2010 at 7:40 am
This article explains it better.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 2, 2010 at 7:54 am
that seems to relate to partitioned indexes
August 2, 2010 at 7:59 am
ive managed to sort it anway, thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply