sql server多行插入

insert student
select '201215121','李勇','男',20,'cs' union
select '201215122','刘晨','女',19,'cs' union
select '201215124','张立','男',19,'is'

insert course
select '1','数据库',null,'4' union
select '2','数学',null,'2' union
select '3','信息系统',null,'4' union
select '4','操作系统',null,'3' union
select '5','数据结构',null,'4' union
select '6','数据处理',null,'2' union
select '7','pascal语言',null,'4'

insert sc
select '201215121','1',92 union
select '201215121','2',85 union
select '201215121','3',88 union
select '201215122','2',90 union
select '201215122','3',80