2、设计并执行事务2：将课程“数据结构”的课程号与“数据库”的课程号互换。

BEGIN TRANSACTION

declare @a int,@b int

SELECT @a=CNO FROM Course WHERE Cname='数据结构'

SELECT @b=CNO FROM Course WHERE Cname='数据库'

update Course set Cno=@a

where Cname in (select Cname from Course where Cname ='数据库')

update Course set Cno=@b

where Cname in (select Cname from Course where Cname ='数据结构')

go

commit

go