将Xml转换为Table SQL Server 2008 [英] Convert Xml to Table SQL Server 2008

问题描述

 <   group  >  
 <   item     text   = 产品     groupimageurl   = < span class =code-keyword>〜/ Img / interior.png    imageposition   =  1 >  
 <  群组 >  
 <   item     text   = 家具 >  
 <   group  >  
 <   item     text   =  桌椅    /  >  
 <   item     text   = 沙发    /  >  
 <   item     text   = 偶尔家具    /  >  
 <   item     text   =  Childerns Furniture    /  >  
 <   item     text   = 床    /  >  
 <   / group  >  
 <   / item  >  
 <  < span class =code-leadattribute> item     text   = 装饰 >  
 <   group    流量  = 垂直 >  
 <   item  < span class =code-attribute>   text   = 床单    /   >  
 <   item     text   = 引发    /  >  
 <   item     text   = 窗帘和百叶窗    /  >  
 <   item     text   =  Rugs < span class =code-attribute>   /  >  
 <   item    文本  = 地毯    /  >  
 < ;   / group  >  
 <   / item  >  
 <   item     text   = 存储 >  
 <   group     flow   = 垂直 >  
 <   item     text   =  Wall Shelving    /  >  
 <   item     text   = 儿童存储   < span class =code-keyword> /  >  
 <   item     text   =  Baskets    /  >  
 <   item     text   = 多媒体存储   < span class =code-keyword> /  >  
 <   item     text   = 楼层搁置    /  >  
 <   item     text   = 卫​​生纸持有人    /  < span class =code-keyword>>  
 <   item     text   = 存储罐    /  >  
 <   item     text   =  抽屉    /  >  
 <   item     text   = 框    /  >  
 <   / group  >  
 <   / item  >  
 <   item     text   = 灯光 >  
 <   group     flow   = 垂直   < span class =code-attribute> offsetx   =   -  26 >  
 <   item     text   = 上限    /  >  
 <   item     text   = 表    /  >  
 <   item     text   =  Floor    /  >  
 <   item     text   = 阴影    /  >  
 <   item     text   = 壁灯    /  >  
 <   item     text   =  Spotlights     /  >  
 <   item     text   = 推光灯    /  >  
 <   item     text   = 字符串灯    /  >  
 <   / group  >  
 <   / item  >  
 <   / group  >  
 <   / item  >  
 <   / group   >  

这是我的XML数据。此数据在Sql Server 2008中转换。



谢谢。

解决方案

这对您的问题似乎是可行的：

http://stackoverflow.com/questions/3989395 / convert-xml-to-table-sql-server [ ^ ]



如果找不到更多此处 [ ^ ]。

<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>

This is my XML data. This data converted in Sql Server 2008.

Thank You.

解决方案

THis seems viable to your problem:
http://stackoverflow.com/questions/3989395/convert-xml-to-table-sql-server[^]

If not lots more found here[^].

这篇关于将Xml转换为Table SQL Server 2008的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！