编程自学免费网站,书店网站的建设,控制网站的大量访问,小程序开发平台花多少钱xml.query()函数#xff0c;XQuery表达式可以返回xml一个单一的元素或是所有元素。 我们继续使用上一篇所创建表[dbo].[tbDevLanguage] http://www.cnblogs.com/insus/archive/2012/02/25/2367668.html 首先我们演示Query所有元素#xff0c;注意一下查询节点#xff0c;返回…xml.query()函数XQuery表达式可以返回xml一个单一的元素或是所有元素。 我们继续使用上一篇所创建表[dbo].[tbDevLanguage] http://www.cnblogs.com/insus/archive/2012/02/25/2367668.html 首先我们演示Query所有元素注意一下查询节点返回结果获取范围 SELECT [languages].query(/Languages) AS [language]FROM [dbo].[tbDevLanguage]SELECT [languages].query(/Languages/language) AS [language]FROM [dbo].[tbDevLanguage] 上两sql语句执行结果 最后再演示一下返回一个元素 SELECT [languages].query(/Languages[1]/language[1]) AS [language]FROM [dbo].[tbDevLanguage]SELECT [languages].query(/Languages[1]/language[2]) AS [language]FROM [dbo].[tbDevLanguage]SELECT [languages].query(/Languages[1]/language[3]) AS [language]FROM [dbo].[tbDevLanguage] 上面三句SQL语句分别取得三个元素 转载于:https://www.cnblogs.com/insus/archive/2012/02/25/2367701.html
