sql server 2005 xml 类型数据读取的问题
建一个表
CREATE TABLE Team
(
TeamID int identity not null,
TeamDoc xml DEFAULT '<Team />' NOT NULL
)
插入数据
INSERT INTO Team (TeamDoc) Values ('<Team name="Braves">
<Players>
<Pitcher name="John Smoltz" role="Closer"/>
<Pitcher name="Russ Ortiz" role="Starter" />
<ThirdBase name="Chipper Jones" role="Starter" bats="switch"/>
</Players>
</Team>
')
执行查询
SELECT TeamDoc.query('/Team/Players/Pitcher')
FROM Team
在sql server 管理器中可以得到结果,但在asp中用ADODB.RecordSet得到的却是空记录集
清高手释疑!!!