SQL生成xml文档

/********************生成xml文档********************/
/********************for xml path********************/
/*
if OBJECT_ID('ct') is not null
  drop table ct
go

create table ct
(
Code int identity(1000,1) primary key not null,
Name varchar(20) ,
Sex varchar(4),
Age int,
Departments varchar(50),
Class varchar(50)
)
go

insert into ct(Name,Sex,Age,Departments,Class)
select 'ct01','男',20,'通信学院','IT0602班'
union all
select 'ct04','女',23,'软件工程学院','C#0602班'
union all
select 'ct03','男',22,'软件工程学院','Java0601班'
union all
select 'ct02','女',21,'通信学院','IT0601班'
go
*/
/********************for xml path********************/
select *
from ct
where Departments='通信学院'
for xml path('Student')
go
/********************for xml path********************/