SQL2005 XML类型的值读取

[tl_pear]

在MOSS中AllLists表中的字段tp_fields(XML类型)的值如下,怎么读取?

12.0.0.4518.0.0<FieldRef Name="ContentTypeId"/><FieldRef Name="Title" ColName="nvarchar1"/><FieldRef Name="_ModerationComments" ColName="ntext1"/><FieldRef Name="File_x0020_Type" ColName="nvarchar2"/>

[areswang]

只能是帮顶了。

[tianhuo_soft]

[Quote=引用 1 楼 areswang 的回复:]
只能是帮顶了。
[/Quote]

[中国风]

declare @xml xml
set @xml='<root><FieldRef Name="ContentTypeId"/>
<FieldRef Name="Title" ColName="nvarchar1"/>
<FieldRef Name="_ModerationComments" ColName="ntext1"/>
<FieldRef Name="File_x0020_Type" ColName="nvarchar2"/></root>'
select
[name]=T.c.value('@Name','nvarchar(max)'),
[ColName]=T.c.value('@ColName','varchar(max)')
from
@xml.nodes('/root/FieldRef')T(c)

--加上[root]

[火星求索]

http://blog.csdn.net/charry0110/archive/2007/12/14/1936664.aspx

[tl_pear]

谢谢!