试试这个
CREATE TABLE #Table1
([Col 1] varchar(5), [Col 2] varchar(5), [Col 3] varchar(5))
;
INSERT INTO #Table1
([Col 1], [Col 2], [Col 3])
VALUES
('val 1', 'Val 2', 'Val 3')
;
SELECT Col,Val FROM
(
SELECT * FROM #Table1
) P
UNPIVOT
(
val FOR Col IN ([Col 1], [Col 2], [Col 3])
) pvt
DROP TABLE #Table1