August 16, 2004 at 1:01 pm
How cani work with XML in sql?What are the required additional things to configure sql server to run xml queries.Can anyone guide me in this issue.
Thanks.
August 16, 2004 at 11:30 pm
Well, your post is a little ... broad ... in its scope, but you don't have to do *anything* to get SQL Server to produce XML query output. You can simply append FOR XML AUTO to any query to get XML results. For more control, use FOR XML RAW or FOR XML EXPLICIT. More information on each of these is in the BOL ... just look for "FOR XML clause" on the Index tab.
To get SQL Server to *respond* to requests sent to IIS, you will need to set up a special virtual directory for IIS using the "Configure SQL XML Support in IIS" MMC Console. This topic is also listed on the Index tab of the BOL, with a couple of links from there. The BOL has examples (if I remember correctly) of all the access methods that are supported.
Good luck,
Chris
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply