代码如下
INSERT Result(StudentNo,StudentNo,StudentResult,ExamDate)
SELECT 'S1200902001',1,80,'2009-9-13' UNION
SELECT 'S1200902002',1,45,'2009-9-13' UNION
SELECT 'S1200902001',2,90,'2008-10-18' UNION
SELECT 'S1200902002',2,60,'2009-10-18' UNION
完全是按照书上来的啊,为什么会出现UNION附近语法错误呢
------解决思路----------------------
INSERT Result(StudentNo,StudentNo,StudentResult,ExamDate)
SELECT 'S1200902001',1,80,'2009-9-13' UNION
SELECT 'S1200902002',1,45,'2009-9-13' UNION
SELECT 'S1200902001',2,90,'2008-10-18' UNION
SELECT 'S1200902002',2,60,'2009-10-18'这里的union去掉
--如果书上真的是这样，那就是尽信书则不如无书