XML

  • 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.

  • This article explains it better.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • that seems to relate to partitioned indexes

  • 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