原表：
我想要把表改成这样的：
SQL 语句怎么写？
------解决思路----------------------
这叫列转行
直接UNION ALL应该就可以了吧
SELECT ID,'A1' AS [项目],A1 AS [值]
UNION ALL
SELECT ID,'A2',A2
UNION ALL
SELECT ID,'A3',A3
------解决思路----------------------
SELECT * FROM应该是这样
(
SELECT ID,'A1' AS [项目],A1 AS [值]
UNION ALL
SELECT ID,'A2',A2
UNION ALL
SELECT ID,'A3',A3
)
ORDER BY ID