Is it possible to show both attributes and elements using OPENXML

[manohars]

Is it possible to show both attributes and elements using OPENXML? How can this be done?

Thanks,
Manohar

 

[hmckillop]

Have a look at BOL, specifically the openXML statement. There is an additional parameter when using openXML allowing a choice of 4 options:
0 - Default to attribute centric mapping
1 - Specify the Attribute centric mapping
2 - Element centric
3 - combined attribute and element.

To use it do something like

SELECT    *
FROM       OPENXML (@idoc, '/ROOT/Customer',3)--the 3 denotes combined.
            WITH (CustomerID  varchar(10),
                  ContactName varchar(20))

"I'm living so far beyond my income that we may almost be said to be living apart