INSERT INTO Subject(SubjecName,ClassHour,GradeId)
SELECT '走进Java编程世界',90,'S1' UNIONSELECT 'HTML和CSS网页技术',90,'S1' UNION
SELECT 'C#语言和数据库技术',90,'S1' UNION
SELECT '走进Java编程世界','90','S1' UNION
消息 102,级别 15,状态 1,第 6 行
'UNION' 附近有语法错误。
SELECT '走进Java编程世界',90,'S1' UNIONSELECT 'HTML和CSS网页技术',90,'S1' UNION
SELECT 'C#语言和数据库技术',90,'S1' UNION
SELECT '走进Java编程世界','90','S1' UNION
消息 102,级别 15,状态 1,第 6 行
'UNION' 附近有语法错误。
INSERT INTO Subject3(SubjecName,ClassHour,GradeId)
SELECT '走进Java编程世界','90','S1' UNION
SELECT 'HTML和CSS网页技术','90','S1' UNION
SELECT 'C#语言和数据库技术','90','S1' UNION
SELECT '走进Java编程世界','90','S1'
SELECT '走进Java编程世界',90,'S1' UNIONSELECT 'HTML和CSS网页技术',90,'S1' UNION
SELECT 'C#语言和数据库技术',90,'S1' UNION
SELECT '走进Java编程世界','90','S1' UNION
SELECT '走进Java编程世界','90','S1' where 1 = 0 -- 也可以以最后拼一个这个出来
SELECT '走进Java编程世界',90,'S1' UNIONSELECT 'HTML和CSS网页技术',90,'S1' UNION
SELECT 'C#语言和数据库技术',90,'S1' UNION
SELECT '走进Java编程世界','90','S1'