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