Converting Sql Data to XML and storing the same in Table

Question

0.00/5 (No votes)

See more:

Dear Friends,

I have create a page display few details.
But the query takes more time to execute the page.
So I have planed to convert the query data to XML format and store it in a table.
Then converting the XML data to display in page.

By executing the this line i can get the XML data but how to store the same in different table.

SQL

Select DT=Getdate() into #TEMP
SELECT * from #TEMP FOR XML AUTO
SELECT * from #TEMP FOR XML RAW

Also kinldy explain me what is difference between XML AUTO and XML RAW

Kindly suggest or guide me on this.

Posted 8-Jan-13 19:39pm

Arunprasath Natarajan

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tejal S · Answer 1 · 2013-01-10T23:00:00

Solution 1

Refre the below link,

http://msdn.microsoft.com/en-us/library/ms191268.aspx[^]

Posted 10-Jan-13 23:00pm

Tejal S

Maciej Los · Answer 2 · 2013-03-03T11:45:00

Quote:
The RAW mode generates a single <row> element per row in the rowset that is returned by the SELECT statement. You can generate XML hierarchy by writing nested FOR XML queries.

The AUTO mode generates nesting in the resulting XML by using heuristics based on the way the SELECT statement is specified. You have minimal control over the shape of the XML generated. The nested FOR XML queries can be written to generate XML hierarchy beyond the XML shape that is generated by AUTO mode heuristics.

More at: http://msdn.microsoft.com/en-us/library/ms178107%28v=sql.105%29.aspx[^]

Converting Sql Data to XML and storing the same in Table

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Converting Sql Data to XML and storing the same in Table

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us