SQL server 修改多行数据

use EMIS
go
select *
from t_student
where student_id in ('2016020126','2016020128','2016020129')
go

update t_student
set class_code = '16wlw301'  --指定需要修改的数列（class_code）和修改值为（16wlw301）
where student_id in ('2016020126','2016020128','2016020129')  --指定更新的条件
go

select *
from t_student
where student_id in ('2016020126','2016020128','2016020129')
go