运用 for xml
但是SQL2000对此支持不好,用SQL2005比较好
SQL语句:
select rtrim(sno) as "@no",rtrim(sname) as "@name",rtrim(ssex) as "@sex"
from student
for xml path('student'),type,root('allStudents')
结果为:
<allStudents>
<student no="08020001" name="李勇" sex="男" />
<student no="08020002" name="刘晨" sex="女" />
<student no="08020003" name="王敏" sex="女" />
<student no="08020004" name="张立" sex="男" />
</allStudents>