将Xml转换为Table SQL Server 2008

本文介绍了将Xml转换为Table SQL Server 2008的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 29岁程序员，3月因学历无情被辞！ < group > < item text = 产品 groupimageurl = 〜/ Img / interior.png imageposition = 1 > < 群组 > < item text = 家具 > < group > < item text = 桌椅 / > < item text = 沙发 / > < item text = 偶尔家具 / > < item text = Childerns Furniture / > < item text = 床 / > < / group > < / item > < item text = 装饰 > < group 流量 = 垂直 > < item text = 床单 / > < item text = 引发 / > < item text = 窗帘和百叶窗 / > < item text = Rugs / > < item 文本 = 地毯 / > < ; / group > < / item > < item text = 存储 > < group flow = 垂直 > < item text = Wall Shelving / > < item text = 儿童存储 / > < item text = Baskets / > < item text = 多媒体存储 / > < item text = 楼层搁置 / > < item text = 卫​​生纸持有人 / > < item text = 存储罐 / > < item text = 抽屉 / > < item text = 框 / > < / group > < / item > < item text = 灯光 > < group flow = 垂直 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的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 上岸，阿里云！