SQL语句
1.select * from (tablename) for xml auto
如NorthWind中的Course表
结果：
"<Course courseid=""1"" coursename=""English""/><Course courseid=""2"" coursename=""Chinese""/><Course courseid=""3"" coursename=""Franch""/><Course courseid=""4"" coursename=""Math""/><Course courseid=""5"" coursename=""Science""/>"
2.select * from (tablename) for xml auto,elements
结果：
<Course><courseid>1</courseid><coursename>English</coursename></Course>
<Course><courseid>2</courseid><coursename>Chinese</coursename></Course>
<Course><courseid>3</courseid><coursename>Franch</coursename></Course>
<Course><courseid>4</courseid><coursename>Math</coursename></Course>
<Course><courseid>5</courseid><coursename>Science</coursename></Course>
