在SQL中生成XML文本
- WBOYOriginal
- 2016-06-07 16:19:271048browse
在SQL中自定义XML的根节点和子节点 select * from table FOR XML PATH('child'),ROOT('parent') 多表查询一个主表一个子表的话 select *, (select * from subTable where subTable.id=master.id FOR XML PATH('child'),ROOT('parent'),TYPE ) from master FO
在SQL中自定义XML的根节点和子节点
select * from table FOR XML PATH('child'),ROOT('parent')
多表查询一个主表一个子表的话
select *,
(select * from subTable where subTable.id=master.id
FOR XML PATH('child'),ROOT('parent'),TYPE
)
from master
FOR XML PATH('child'),ROOT('parent')
，Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：sql server 2005进程无法向表“"dbo"."xxx"”进行大容量复制Next article：mysql性能最大化