22,301
社区成员




declare @class as int
select @class = n.class from class m , student n where m.cid = n.class and m.cstate <> '毕业'
delete from student where sid = @class
delete from class where cid = @class
DELETE A FROM STUDENT A, CLASS B WHERE A.CLASS=B.CID AND B.CSTATE='毕业'
DELETE CLASS WHERE CSTATE='毕业'