Click here to Skip to main content
13,095,218 members (84,060 online)
Rate this:
Please Sign up or sign in to vote.
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.
Select DT=Getdate() into #TEMP

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
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Rate this: bad
Please Sign up or sign in to vote.

Solution 2

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:[^]
RedDK 4-Mar-13 12:49pm
Hey ML,

I saw a post yesterday, deep in the stack somewhere here in CPQA, that suggested there was a temp file of this .xml output. Is that notion true? And if it is, which temp might contain it? Sorry AN for hijacking your thread a little ...

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web04 | 2.8.170813.1 | Last Updated 3 Mar 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100