用sql语句将行转列

表结构和内容：

insert into test(val1,val2) values('name','wd');
insert into test(val1,val2) values('email','jon_wd@163.com');
insert into test(val1,val2) values('age','30');

 

SQL语句：

declare @s varchar(8000) 

set @s = 'select ';

select @s = @s + val1 +' = max(case when val1 = ''' + val1 + ''' then val2 end), '
from test
set @s = left(@s, len(@s) - 1)
set @s = @s + ' from test'

 

exec(@s)