linq 取Sql 2008里面XML字段中的值

Question

<AdOrder ID="" AdTypeID="2" ItemTemplateID="1685889961" CreateUser="360" UpdateUser="360" CreateTime="2011-07-12T12:10:37.4357205+08:00" UpdateTime="2011-07-12T12:10:37.4357205+08:00">
  <DB Publication="0" IssueList="1,0," AllTemplateClassId="1,2,3,5," TemplateClassId="5" Itemplate="1685889961" ItemplateSize="1*1_Car" Price="20" />
  <Content UnitCellsID="43" RowsCount="20" CellsCount="1" UnitCellsWidth="136.771657347679" UnitCellsHeight="8.69102386379242" />
  <Content TagName="Year" TagType="0">6</Content>
  <Content TagName="Price" TagType="0">6</Content>
  <Content TagName="ContactNo" TagType="0">6</Content>
  <Content TagName="ContactPerson" TagType="0">6</Content>
  <Content TagName="Description" TagType="0">6</Content>
  <Content TagName="Name" TagType="0">6</Content>
  <Content TagName="Brand" TagType="0">6</Content>
  <Content TagName="Pic1" TagType="1">-1350990177_userload_1IMG_0264.jpg</Content>
</AdOrder>上面是一张表里面的一个字段，要取Publication的值做判断，怎么取的呢

Answer 1

SQL Server 2005 XML 操作总结（五）元素（节点）操作——修改、删除、移动、遍历操作

Answer 2

DECLARE @idoc int
DECLARE @doc xmlselect @doc = '
<AdOrder ID="" AdTypeID="2" ItemTemplateID="1685889961" CreateUser="360" UpdateUser="360" CreateTime="2011-07-12T12:10:37.4357205+08:00" UpdateTime="2011-07-12T12:10:37.4357205+08:00">
  <DB Publication="0" IssueList="1,0," AllTemplateClassId="1,2,3,5," TemplateClassId="5" Itemplate="1685889961" ItemplateSize="1*1_Car" Price="20" />
  <Content UnitCellsID="43" RowsCount="20" CellsCount="1" UnitCellsWidth="136.771657347679" UnitCellsHeight="8.69102386379242" />
  <Content TagName="Year" TagType="0">6</Content>
  <Content TagName="Price" TagType="0">6</Content>
  <Content TagName="ContactNo" TagType="0">6</Content>
  <Content TagName="ContactPerson" TagType="0">6</Content>
  <Content TagName="Description" TagType="0">6</Content>
  <Content TagName="Name" TagType="0">6</Content>
  <Content TagName="Brand" TagType="0">6</Content>
  <Content TagName="Pic1" TagType="1">-1350990177_userload_1IMG_0264.jpg</Content>
--</AdOrder>'EXEC sp_xml_preparedocument @idoc OUTPUT, @docSELECT Publication FROM 
OPENXML (@idoc, '/AdOrder/DB',1)
WITH (Publication varchar(100))-- 结果
Publication
-------------
0