Hi,

I have a scenario where I need to create an XML by fetching data from a table in the SQL Server 2000 database and the resulting XML should adhere to the schema specified in a given XSD document. I need to achieve this using a VB.net program or any other methodology.

Please help me, since this is an urgent requirement.

thanking you

regards
sasidhar

thanks,
Sasidhar

thanks,
Sasidhar

__________________
thanks,
Sasidhar

You should look at "FOR XML" in the SQL Server online help at msdn.com. You can creeate a simple XML output by adding this to a standard query. For advanced control you need the "FOR XML EXPLICIT" version. If you can use SQL Server 2005 then yoou have an easier option with "FOR XML PATH".



--

Joe (Microsoft MVP - XML)

Hi ,

Thank you very much.

But I need to use XSD for generating the xml.

how can I use that too.

regards
sasidhar

thanks,
Sasidhar