Преобразование Xml в таблицу SQL Server 2008
<group> <item text="Products" groupimageurl="~/Img/interior.png" imageposition="1"> <group> <item text="Furniture"> <group> <item text="Tables and Chairs" /> <item text="Sofas" /> <item text="Occasional Furniture" /> <item text="Childerns Furniture" /> <item text="Beds" /> </group> </item> <item text="Decor"> <group flow="Vertical"> <item text="Bed Linen" /> <item text="Throws" /> <item text="Curtains and Blinds" /> <item text="Rugs" /> <item text="Carpets" /> </group> </item> <item text="Storage"> <group flow="Vertical"> <item text="Wall Shelving" /> <item text="Kids Storage" /> <item text="Baskets" /> <item text="Multimedia Storage" /> <item text="Floor Shelving" /> <item text="Toilet Roll Holders" /> <item text="Storage Jars" /> <item text="Drawers" /> <item text="Boxes" /> </group> </item> <item text="Lights"> <group flow="Vertical" offsetx="-26"> <item text="Ceiling" /> <item text="Table" /> <item text="Floor" /> <item text="Shades" /> <item text="Wall Lights" /> <item text="Spotlights" /> <item text="Push Light" /> <item text="String Lights" /> </group> </item> </group> </item> </group>
Это мои XML-данные. Эти данные преобразуются в Sql Server 2008.
Спасибо.