Search
Querying XML Using the Edge Table Format
Recently I was asked by one of our customers about querying XML in a relational format. “Sure”, I answered, “you can use OPENXML to retrieve a relational representation of the XML”. For example, if the XML looks like this: XHTML <Customers> <Customer Id="1" Name="Mickey Mouse"> <Order Number="12345" Date="2010-01-17"/> <Order Number="23456" Date="2010-01-19"/> </Customer> <Customer Id="2" Name="Donald Duck"> <Order Number="34567" Date="2010-01-12"/> <Ord