将行转换为列而不进行任何计算

Question

我有一个只有单列的表。我怎么把这些行转换成列呢?

tbody> <<tr>

colorcode
去
# 339966
# 800080
# FF9900

我不知道如何动态生成列名，如果你能组合sql脚本，你可以使用组合字符串脚本来执行。

with code as (
select '#FFCC00' as ColourCode 
union
select '#339966' as ColourCode 
union
select '#800080' as ColourCode 
union
select '#FF9900' as ColourCode )
select *
from
(select ColourCode , 
'C' + cast( ROW_NUMBER() OVER (Order by (select 1)) as nvarchar(max)) as rn -- generate sequence number
from code ) as sourcetable
PIVOT  
(  
max(ColourCode)  
FOR rn IN ([C1],[C2],[C3],[C4])  -- predifned column Name, if you want to dynamic generated, you should use variable 
) AS PivotTable;