sql数据类型转换

sql 字符串类型转成xml类型

SELECT convert(xml,N'<root><list><id>4965252</id><path>/supply/2013/1/20/22/4000815960579.jpg</path><size>0</size></list><list><id>4965251</id><path>/supply/2013/1/20/22/923860818577866.jpg</path><size>0</size></list><list><id>4965265</id><path>/supply/2013/1/20/22/0229180669518737.jpg</path><size>0</size></list><list><id>4965264</id><path>/supply/2013/1/20/22/215270536120641.jpg</path><size>0</size></list><list><id>4965250</id><path>/supply/2013/1/20/22/769160875477437.jpg</path><size>0</size></list></root>')