SQL列转行,行转列
efg', 2, 3, '12345');查询结果:a12345efg行转列静态SQL:SELECT *
FROM StudentScores
PIVOT(SUM(Score)
FOR Subject IN(生物, 数学, 英语, 语文))T;动态SQL:DECLARE @sql VARCHAR(8000);
SELECT @sql=ISNULL(@sql+',', '')+Subject
FROM StudentScores
GROUP BY Subject;
SET @sql='SE