I have Database with the following structure: Regions -> Countries -> Customers -> Fabs -> Products. All relationships are one to many.
I need to build query that returns all data of any Region as XML.
What is the best way to do opposite action (Export from XML to DB) ?I just played with this over the weekend for the first time. Please take a look at "XML and Internet Support Overview" in SQL Server Books Online.
Once you configure this properly with IIS you can return auto generated XML from querying SQL Server.
What little I did, it was pretty cool.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment