SQL server 数据库批量添加学生信息

use EMIS
go 
select *
from t_student   --选择学生表来添加信息
where class_code = '17wljs301'    --指定需要添加信息的班级
go 

insert into t_student
values
	('2017020101','刘一','女','2001-3-4','2017-9-1','17wljs301','01','liuyi','19814535273'),
	('2017020102','陈二','男','2001-3-8','2017-9-1','17wljs301','01','chener','19814535273'),
	('2017020103','张三','男','2001-2-4','2017-9-1','17wljs301','01','zhangsan','19814535273'),
	('2017020104','李四','男','2001-4-6','2017-9-1','17wljs301','01','lisi','19814535273'),
	('2017020105','王五','男','2001-4-11','2017-9-1','17wljs301','01','','')
go

select *
from t_student
where class_code = '17wljs301'
go