BEGIN TRANSACTION
go
use 学生选课
go
update SC set Grade=99
where Sno in (select Sno from Student where Sname ='刘晨')
and Cno='2'
go
commit
go
作业:设计并执行事务1:将学生“刘晨”的“数学”课程成绩改为88分。(请做该题)
BEGIN TRANSACTION
go
update SC set Grade=89
where Sno in (select Sno from Student where Sname ='刘晨')
and Cno='2'
go
commit
go