一些操作符

转载

mob604756e80bb7 2010-11-01 11:40:00

文章标签 xml 编程 文章分类 代码人生

DECLARE @x XML

SELECT @x = '

<Peoples>

  <People NAME="周星驰"/>

  <People NAME="刘德华"/>

  <People NAME="周杰伦"/>

</Peoples>'



SELECT  @X.query('(/Peoples) ')
/*
<Peoples>
  <People NAME="周星驰" />
  <People NAME="刘德华" />
  <People NAME="周杰伦" />
</Peoples>
*/

SELECT  @X.query('(/Peoples/People[last()]) ')

/*
<People NAME="周杰伦" />
*/

SELECT  @X.query('(/Peoples/People[.]) ')
/*
<People NAME="周星驰" />
<People NAME="刘德华" />
<People NAME="周杰伦" />
*/


SELECT  @X.query('(/Peoples/People[. >> (/Peoples/People[@NAME="周星驰"])[1]])  [last()] ')
/*
  <People NAME="周杰伦" />
*/

SELECT  @X.query('(/Peoples/People [. is (/Peoples/People[@NAME="周星驰"])[last()]]  )')

/*
<People NAME="周星驰" />
*/
SELECT  @X.query('(/Peoples/People [. is (/Peoples/People[@NAME="周星驰"])[1]]  )')

/*
<People NAME="周星驰" />
*/
SELECT  @X.query('( . is .)')


SELECT  @X.query('(/Peoples/People [. is  (/Peoples/People[@NAME="周星驰"])[1]]  )')




/*

<People NAME="周星驰" />

*/

本文章为转载内容，我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题，欢迎原作者联系我们进行内容更正或删除文章。