Querying and Managing XML Data

12 Articles

Introduction to XML

Last Updated On : Sunday, May 24, 2015This lesson introduces XML through samples. The following is an example of an XML document, created with a FOR XML clause of the SELECT statement. <CustomersOrders> <Customer custid=”1″ companyname=”Customer NRZBB”> <Order orderid=”10692″ orderdate=”2007-10-03T00:00:00″ /> <Order orderid=”10702″ orderdate=”2007-10-13T00:00:00″ /> <Order orderid=”10952″ orderdate=”2008-03-16T00:00:00″ /> </Customer> <Customer custid=”2″ companyname=”Customer MLTDN”> <Order […]