Convert SQL server data tables to XML

Use for XML, but SQL2000 does not support this well. Use sql2005, for example, the following table: SnO sname ssex08020001 LI Yong male 08020002 Liu Chen female 08020003 Wang Min female 08020004 Zhang Li male SQL statement: Select rtrim (SNO) as "@ No", rtrim (sname) as "@ name", rtrim (ssex) as "@ sex" from studentfor XML Path ('student '), type, the result of root ('allstudents') is: <allstudents> <student no = "08020001" name = "LI Yong" Sex = "male"/> <student no = "08020002" name = "Liu Chen" Sex = "female "/> <student no = "08020003" name = "Wang Min" Sex = "female"/> <student no = "08020004" name = "Zhang Li" Sex = "male"/> </allstudents>