how can we store a sql querry inside an xml node

Question

how can we store a sql querry inside an xml node

shameej_thbs

SSC Journeyman

Points: 98
More actions
July 1, 2010 at 5:45 am

#139616

Hi All,
I am new to XML
how can we store a sql querry inside an xml node

Viewing 4 posts - 1 through 3 (of 3 total)

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

Adi Cohn-120898 SSC-Dedicated Points: 33944 More actions · Answer 1

I’m guessing that you meant that you want to get the query’s result as an XML document and not the query itself. If I’m correct, then you need to add at the end of the query the FOR XML clause. You can read more about it in this link http://msdn.microsoft.com/en-us/library/ms178107.aspx%5B/url%5D

Adi

--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

shameej_thbs SSC Journeyman Points: 98 More actions · Answer 2

not result data..

how can i give querry itself inside an xml node

Adi Cohn-120898 SSC-Dedicated Points: 33944 More actions · Answer 3

You need to give more information and explain what you need to do. There are many ways to write a query in an XML document (for example open up notepad and writing the XML with the query).

Adi

--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/