将sql转换成xml

表结构：SELECT [Cno]
      ,[Cname]
      ,[Cnum]
  FROM [testDB].[dbo].[codeInfo]

select rtrim(Cno) as "@Cno",rtrim(Cname) as "@Cname",rtrim(Cnum) as "@Cnum" 
from codeinfo 

for xml path('student'),type,root('allStudents') 

结果：

<allStudents>
  <student Cno="1" Cname="1" Cnum="1" />
  <student Cno="2" Cname="2" Cnum="2" />
  <student Cno="3" Cname="3" Cnum="3" />
  <student Cno="4" Cname="4" Cnum="4" />
</allStudents>