34,588
社区成员
发帖
与我相关
我的任务
分享
INSERT INTO dbo.score1
SELECT ROW_NUMBER()OVER(ORDER BY t.studid,t.subjid),*
FROM ( SELECT id studid,
1 AS subjid,
subject1 AS grade
FROM student1
UNION ALL
SELECT id,
2 ,
subject2
FROM student1
UNION ALL
SELECT id,
3 ,
subject3
FROM student1
UNION ALL
SELECT id,
4 ,
subject4
FROM student1
UNION ALL
SELECT id,
5 ,
subject5
FROM student1
UNION ALL
SELECT id,
6 ,
subject6
FROM student1
) t
SELECT ROW_NUMBER()OVER(ORDER BY t.studid,t.subjid),*
FROM ( SELECT id studid,
1 AS subjid,
subject1 AS grade
FROM student1
UNION ALL
SELECT id,
2 ,
subject2
FROM student1
UNION ALL
SELECT id,
3 ,
subject3
FROM student1
UNION ALL
SELECT id,
4 ,
subject4
FROM student1
UNION ALL
SELECT id,
5 ,
subject5
FROM student1
UNION ALL
SELECT id,
6 ,
subject6
FROM student1
) t