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>
转载于:https://www.cnblogs.com/kinter/archive/2005/12/23/303338.html