SQL Server and XML Schemas

[WOTRAC]

I have a reasonable working knowledge of SQL queries and Stored Procedures and a basic understanding of XML.

What I want to do is extract data from SQL server and output it to XML using a predefined XML Schema for Validation, but am not sure where to start.


Could anyone suggest where I should start, or point me in the direction of some good tutorials



Thanks

 

[chiph]

SQL Server has a couple of XML formats that it uses, depending on if you use the FOR XML or FOR XML AUTO in your query. It does not run queries that result in an arbitrary format.

However, you can take the format that it outputs and run it through a XSLT to transform it into something that you can use.

Chip H.


If you want to get the best response to a question, please check out FAQ222-2244 first