SQL server 语句删除部分数据

use EMIS
go
select *
from t_course_reg
where student_id = '2017020101'
go

delete
from t_course_reg    --要删除的表
where student_id = '2017020101' --要删除的数据条件
go

select *
from t_course_reg
where student_id = '2017020101'
go