SqlServer 行转列

--行转列 

CREATE TABLE [dbo].[tb](
[id] [varchar](3) NULL,
[pid] [varchar](3) NULL,
[name] [varchar](10) NULL
) ON [PRIMARY]

insert into tb values('001' , null  , '广东省')
insert into tb values('002' , '001' , '广州市')
insert into tb values('003' , '001' , '深圳市')
insert into tb values('004' , '002' , '天河区')
insert into tb values('005' , '003' , '罗湖区')
insert into tb values('006' , '003' , '福田区')
insert into tb values('007' , '003' , '宝安区')
insert into tb values('008' , '007' , '西乡镇')
insert into tb values('009' , '007' , '龙华镇')
insert into tb values('010' , '007' , '松岗镇')
go

SELECT * FROM  tb
--使用行转列
 select  ','+name from tb  FOR xml path('') 
 --
 SELECT ',' +name FROM tb where pid = 0007  for XML PATH ('')