convert sql to XML

Question

hi this is kavita
I m new in XML.I am using sql database and many table in that and at a time around 5 lack record in a some table. I want to use XML to store my data. Is it possible in xml a table structure like sql or access not text file.

thanks in advance!!!

kavita · Answer

hi abhisek kavita here. I have also send u an email.We help each other. reply me on my email id. bye

abhishek trivedi · Answer

Hii Abhishek Here!! Actually i think we should fix some time that we both are online at same time so it may help both of us solve our problem somewhat faster?if you think it is right then reply me on this post then we will continue from there.

abhishek trivedi · Answer

Hii Abhishek Here!! yes you can store your data in xml file. you have to create one file in xml and you can also insert data inside that xml file somewhat simillar to sql server only classes are different. i think it will also increase your performance since you are lightening the database in great deal.

surendra kumar · Answer

write this type of query for generating sql data to xml data select * from authors for xml auto