Storing XML data in a table

Question

Post reply

Storing XML data in a table

Sapna Ranka

SSC Eights!

Points: 810
More actions
July 14, 2005 at 7:47 pm

#66316

I am trying to convert data into XML Format. I tried converting data using the FOR XML clause. But there is no way I can Load the result set into a table or a local variable since sql server does not allow the use of insert statment with the XML clause. Is there anyway I can create XML data using SQL and load it into a column with NTEXT datatype or NVARCHAR datataype.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

Here's my humble question. Why do you want to do that ???

Sapna Ranka SSC Eights! Points: 810 More actions · Answer 2

I am trying to store data from many tables into one by converting each row into XML.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

Ya I can figure that, but why would you want to denormalize your model, make it alsmot impossible to maintain, impossible to validate the data and maybe even slow it down??

Sapna Ranka SSC Eights! Points: 810 More actions · Answer 4

Once I have loaded my table with all the XML data. I will convert it into a file, and will store it where ever the user wants to. Then when restoring will extract all the data from the XML and restore it into my tables

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 5

I don't wanna seem rude but I either don't understand what you really want to do or you need to learn how to do backups using sql server tools or other third party software. Xml is not the solution for this problem.