數(shù)據(jù)庫(kù)實(shí)驗(yàn)總結(jié)-wenkub.com
2024-09-30 09:37 本頁(yè)面
【正文】 刪除2小題所建立的約束。sex39。男39。39。[0~9999]39。default_sex39。tr39。)drop trigger worker_delete go create trigger worker_delete on worker for delete as delete salary where =(select 職工號(hào) from deleted)(3)刪除觸發(fā)器depart_update(4)刪除觸發(fā)器worker_delete(5)在數(shù)據(jù)庫(kù)中創(chuàng)建一個(gè)觸發(fā)器，向選課表添加一條紀(jì)錄時(shí)，檢查該紀(jì)錄的學(xué)號(hào)在學(xué)生表中是否存在，檢查該紀(jì)錄的課程號(hào)在課程表中是否存在，若其中有一項(xiàng)為否，則拒絕添加操作，并顯示“違反數(shù)據(jù)一致性”提示信息。Go If exists(select name from sysobjects where name=39。depart_update39。)drop procedure select_sno go create procedure select_sno Sno char(5)as select Sno,Sname from Student where Sno=Sno go exec select_sno 39。)drop procedure select_stu go create procedure select_stu as select ,Sname,Cname,Grade from Student,SC,Course where = and = go exec select_stu ，姓名，該存儲(chǔ)過程接受與傳遞參數(shù)，精確匹配的值 use 霍雙雙200826351 go if exists(select name from sysobjects where name=39。drop procedure Addworker, Delworker（5）創(chuàng)建并執(zhí)行以下存儲(chǔ)過程：，返回學(xué)生學(xué)號(hào)、姓名、課程名、成績(jī) use 霍雙雙200826351 go if exists(select name from sysobjects where name=39。)drop procedure Delworker go create procedure Delworker 職工號(hào) char(4)as delete from worker where 職工號(hào)=職工號(hào)go exec Delworker 39。（2）創(chuàng)建一個(gè)存儲(chǔ)過程Delworker刪除worker表中指定職工號(hào)的記錄 goif exists(select name from sysobjects where name=39。,39。,39。,39。 and type=39。,Cno as 39。select substring(Cname,1,2)from Course(7).在一列中顯示student中各元組的學(xué)號(hào)中的年級(jí)，列名顯示為“年級(jí)”；另一列中顯示學(xué)號(hào)中的學(xué)生序列號(hào)，列名顯示為“序號(hào)”。男39。 print avg end（3）.如果有成績(jī)?cè)?0分以上的學(xué)生,則顯示他的學(xué)號(hào),課程和成績(jī),否則顯示“沒有學(xué)生的課程成績(jī)?cè)?0分以上”提示信息declare text char(10)if exists(select grade from SC where grade90)select Sno,Cno,Grade from SC where Grade90 else begin set text=39。 else begin select avg=avg(grade)from sc where sno=39。（2）計(jì)算并輸出95003號(hào)學(xué)生的平均成績(jī)，若無該生信息，則顯示“該生未選課”, avg float if(select count(*)from sc where sno=39。)if avg80print39。,filename=39。,filename=39。 and o=39。Select avg(grade)from sc where o=’3’ 。)。Select sname from student where ssex in(select ssex from student where sname=39。SELECT sname from student where ssex in(select ssex from student where sname=39
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1