查询结果的处理问题

[letsband]

假设利用
select field_a, field_b from table where id=1

查询到的结果如下

-------------------------
| field_a | field_b |
-------------------------
| value_1 | value_2 |
-------------------------

我想将结果处理为

-------------------------
| field_a | value_1 |
-------------------------
| field_b | value_2 |
-------------------------

怎样在MSSQL里实现？

[caiyunxia]

引用
declare @name char(7),@sql varchar(500)

set @sql='create table test2 ('

declare mycursor cursor for
select 名称 from test1 --名称是要成为列的那个字段

open mycursor

fetch next from mycursor into @name

while @@fetch_status=0
begin
set @sql=@sql+@name+' char(8),'

fetch next from mycursor into @name
end

set @sql=substring(@sql,1,len(@sql)-1)+')'

exec(@sql)