declare @t table ( contenct xml)insert into @t select
'<?xml version="1.0"?>
<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(
' every $dept in /product/@dept
satisfies ($dept = "ACC")'
)from @t
执行结果(1 行受影响)---------------------------------------------------------------------
true(1 行受影响)
而这个语句在stylus studio 里面
结果是falsexquery 语句
every $dept in doc("catalog.xml")//product/@dept
satisfies ($dept = "ACC")请大家帮忙判断一下catalog.xml
----------------------------<?xml version="1.0"?>
<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>
'<?xml version="1.0"?>
<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(
' every $dept in /product/@dept
satisfies ($dept = "ACC")'
)from @t
执行结果(1 行受影响)---------------------------------------------------------------------
true(1 行受影响)
而这个语句在stylus studio 里面
结果是falsexquery 语句
every $dept in doc("catalog.xml")//product/@dept
satisfies ($dept = "ACC")请大家帮忙判断一下catalog.xml
----------------------------<?xml version="1.0"?>
<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>
解决方案 »
- check约束问题
- 如何显示某张表里,字段数据都不重复的记录?[谢谢,急]
- 请教MS-SQL语法
- asp中的四表数据查询的select语句有什么错误,急!!!!!!!!!请帮忙!!!跪求!!
- !!!奇怪的问题 OPENROWSET!!!
- vista下sql server 2005无法启用sql server身份认证
- 写存储过程中怎样生成一个关于时间的随机数
- 如何配置SQL server2000连接池
- 如果在查询分析器中删除excel里的数据?
- 对等复制中,如何修改表的结构
- access的id如何从1000开始
- 我用Microsoft.Jet.OLEDB.4.0导入Excel文件,导入的时间数据怎么没有秒的值
' every $dept in /product/@dept
satisfies ($dept = "ACC")'
)
' every $dept in //product/@dept
satisfies ($dept = "ACC")'
路径写错了楼主,明显是false,用some是true
in catalog/product/@dept