use EMIS
go
select *
from t_student
where student_id = '2017020101'
go
update t_student
set status = '02' --指定需要修改的数列(status)和修改值为(02)
where student_id = '2017020101' --指定更新的条件
go
select *
from t_student
where student_id = '2017020101'
go
SQL server 修改单行数据
最新推荐文章于 2024-04-29 09:15:37 发布