提供Detail的XML串格式,格式最好定义为标准格式
比如
Create table Tb_ Customer (id int,name nvarchar(10),Sex nvarchar(10),Age int)
insert into tb_Customer (Name,Sex,Age)(
select '张三' as name,'男' as Sex,20 as Age union all
select '李三' as name,'男' as Sex,20 as Age union all
select '王三' as name,'男' as Sex,20 as Age union all
select '赵三' as name,'女' as Sex,19 as Age
)
select * from Tb_ Customer for xml auto,root('doc')