How to compose an xml file using a schema ?

[chandimapa]

Hi there,

I have a database table and a schema, I want to compose an XML file. How do I do that in SQL Server 2005? Please point me to some expels and/or tutorials on this.

SQL Server 2K has XML composing capabilities, for example, you can create XML by using XPath queries or using MSXML parser (ex. sp_xml_preparedocument). But I want to compose an XML file using a schema. Is this an easier to do in SQL Server 2005?

Thanks,
Chandi