分列顯示

usetest
go

--生成測試臨時表#
ifnotobject_id('Tempdb..#')isnull
droptable#

select
top35
[Name]=cast([Name]asnvarchar(50))
into#
from
syscolumns
where
Name>''

-----35行分6列顯示
select
*
from
(select
Name,
[Ntile],
[Row]=row_number()over(partitionby[Ntile]orderby[Ntile])
from
(select
*,
[Ntile]=Ntile(6)over(orderbyName)
from#)T
)Tmp
pivot
(max(Name)for[Ntile]in([1],[2],[3],[4],[5],[6])
)Tmp2
/**//*
Row123456
--------------------------------------------------------------------------------------------------------
1base_schema_veridrefdatesysstatxtypeimpid
2cacheindexdelreplinfotypedpagesindid
3categoryinfoschema_veruidfirstkeycnt
4crdateinstrigseltrigupdtrigFirstIAMkeys
5deltrignamestats_schema_veruserstatgroupidlockflags
6ftcatidparent_objstatusversionidNULL

(6個資料列受到影響)


*/