declare @t table ( contenct xml)insert into @t select
'<catalog>
<product dept="WMN">
<number>557</number>
<name language="en">Fleece Pullover</name>
<colorChoices>navy black</colorChoices>
</product>
<product dept="ACC">
<number>563</number>
<name language="en">Floppy Sun Hat</name>
</product>
<product dept="ACC">
<number>443</number>
<name language="en">Deluxe Travel Bag</name>
</product>
<product dept="MEN">
<number>784</number>
<name language="en">Cotton Dress Shirt</name>
<colorChoices>white gray</colorChoices>
<desc>Our <i>favorite</i> shirt!</desc>
</product>
</catalog>'SELECT contenct.query(
'for $prod in /catalog/product
where $prod/@dept = "ACC"
order by $prod/number
return $prod/number'
) from @t
'<catalog>
<product dept="WMN">
<number>557</number>
<name language="en">Fleece Pullover</name>
<colorChoices>navy black</colorChoices>
</product>
<product dept="ACC">
<number>563</number>
<name language="en">Floppy Sun Hat</name>
</product>
<product dept="ACC">
<number>443</number>
<name language="en">Deluxe Travel Bag</name>
</product>
<product dept="MEN">
<number>784</number>
<name language="en">Cotton Dress Shirt</name>
<colorChoices>white gray</colorChoices>
<desc>Our <i>favorite</i> shirt!</desc>
</product>
</catalog>'SELECT contenct.query(
'for $prod in /catalog/product
where $prod/@dept = "ACC"
order by $prod/number
return $prod/number'
) from @t
解决方案 »
- 请教SQL视图的问题?急急……
- 新年好,请高手帮忙,写一条Select查询语句。
- sql2000中有什么办法可以读写本地文件,如文本文件
- 求助:存储过程中的IN语句
- 求一条SQL汇总语句
- 有个SQL语句不会写,请帮忙!
- 求Transact SQL的字符串函数
- 问一个菜鸟级的问题!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- 我在一个事物处理中一次插入2500条数据,为何数据库中只有450条左右的记录?用的是MS SQL SERVER!
- 求助,游标必须声明变量的错误
- about sql2005中字符串匹配内置函数和LIKE的性能问题(裸求)
- 请求各位大侠:"llVal":is not a member of 'tagVARIANT'(为什么我的_variant_t 没有64类型,该如何解决这个问题) 开发环境 VC6+ADO
declare @t table ( contenct xml) insert into @t select
' <catalog>
<product dept="WMN">
<number>557 </number>
<name language="en">Fleece Pullover </name>
<colorChoices>navy black </colorChoices>
</product>
<product dept="ACC">
<number>563 </number>
<name language="en">Floppy Sun Hat </name>
</product>
<product dept="ACC">
<number>443 </number>
<name language="en">Deluxe Travel Bag </name>
</product>
<product dept="MEN">
<number>784 </number>
<name language="en">Cotton Dress Shirt </name>
<colorChoices>white gray </colorChoices>
<desc>Our <i>favorite </i> shirt! </desc>
</product>
</catalog>' SELECT contenct.query(
'for $prod in /catalog/product
where $prod/@dept = "ACC"
return $prod/number'
) from @t
sql里面有什么要求吗