设计并执行事务1：将学生“刘晨”的2号课程成绩改为99分。

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