DECLARE @S NVARCHAR(1000)
SELECT @S='SELECT [USER_NAME] AS 姓名'
SELECT @S=@S+',SUM(CASE WHEN COURSE='''+CAST(COURSE AS VARCHAR)+'''THEN SCORE END) AS '+COURSE FROM TEST_TB_GRADE GROUP BY COURSE
SELECT @S=@S+' FROM TEST_TB_GRADE GROUP BY [USER_NAME]'
EXEC(@S)
--這一句怎么沒有select
SUM(CASE WHEN COURSE='''+CAST(COURSE AS VARCHAR)+'''THEN SCORE END) AS '+COURSE FROM TEST_TB_GRADE GROUP BY COURSE
sql server中這一句怎么沒有select
精慕HU
2018-12-06 18:04:00
