Êý¾ÝÒÔxml¸ñʽ·µ»Ø - MS-SQL Server / Ó¦ÓÃʵÀý

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ

XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked" isBranch="true" label="¼¼Êõ¿Æ" >
<folder state="unchecked" isBranch="false" label="ÕÅÈý" />
<folder state="unchecked" isBranch="false" label="ÀîËÄ" />
<folder state="unchecked" isBranch="false" label="ÍõÎå" />
<folder state="unchecked" isBranch="false" label="ÕÔÁù" />
......
¡¡¡¡ </folder>
¡¡¡¡ <folder state="unchecked" isBranch="true" label="Éú²ú¿Æ" >
<folder state="unchecked" isBranch="false" label="Å£Æß" />
<folder state="unchecked" isBranch="false" label="Âí°Ë" />
......
¡¡¡¡ </folder>
......
</folder>

---

ѧϰ Õâ¸ö¡·¡£

---

ÓÐÇëPÁº

---

select * from t_record FOR XML AUTO

---

µÈµ½´ð°¸

---

ding

---

if object_id('tb') is not null
drop table tb
go
create table tb(id int,name varchar(20))
insert into tb(id,name)
select 1,'zy' u