27,579
社区成员
发帖
与我相关
我的任务
分享
select
(case s.number when 0 then 'A' when 1 then 'B' when 2 then 'C' when 3 then 'D' end) col,
(case s.number when 0 then tb.A when 1 then tb.B when 2 then tb.C when 3 then tb.D end) value
from tb, master.dbo.spt_value s
where s.type='P' and s.number<4
SELECT 'A' COL,A VALUE FROM #tpp t
UNION
SELECT 'B' COL,B VALUE FROM #tpp t
UNION
SELECT 'C' COL,C VALUE FROM #tpp t
UNION
SELECT 'D' COL,D VALUE FROM #tpp t
COL VALUE
---- ----------------------
A 23.1
B 11.5
C 20.3
D 18.2
(4 row(s) affected)
CREATE TABLE #tpp
(
A FLOAT,
B FLOAT,
C FLOAT,
D FLOAT
)
INSERT INTO #tpp
SELECT 23.1, 11.5, 20.3 ,18.2
SELECT COL ,VALUE FROM #tpp
UNPIVOT(VALUE FOR COL IN([A],[B],[C],[D]))UNPVT
COL VALUE
-------------- ----
A 23.1
B 11.5
C 20.3
D 18.2
(4 row(s) affected)