sql列转行

create table tb(xinming nvarchar(10) , kecheng nvarchar(10) , fengshu int)
insert into tb values('a' , 'yuwen' , 74)
insert into tb values('a' , 'shuxue' , 83)
insert into tb values('a' , 'wuli' , 93)
insert into tb values('b' , 'yuwen' , 74)
insert into tb values('b' , 'shuxue' , 84)
insert into tb values('b' , 'wuli' , 94)
go

select * from tb

declare @sql varchar(8000)
set @sql = 'select xinming '
select @sql = @sql + ' , max(case kecheng when ''' + kecheng + ''' then fengshu else 0 end) [' + kecheng + ']'
from (select distinct kecheng from tb) as a
set @sql = @sql + ' from tb group by xinming'
print(@sql)
exec(@sql)