數(shù)據(jù)庫實驗總結-閱讀頁
2024-09-30 09:37本頁面
【正文】 tudent中各元組的學號中的年級，列名顯示為“年級”；另一列中顯示學號中的學生序列號，列名顯示為“序號”?！眘elect Sno as 39。,Cno as 39。, grade =case when Grade=60 and Grade=80 and Grade（1）創(chuàng)建一個為worker表添加職工記錄的存儲過程Addworker goif exists(select name from sysobjects where name=39。 and type=39。)drop procedure Addworker go create proc Addworker 職工號 char(4),姓名 char(8),性別 char(2),出生日期 datetime,黨員否 char(2),參加工作 datetime,部門號 char(4)as insert into worker(職工號,姓名,性別,出生日期,黨員否,參加工作,部門號)values(職工號,姓名,性別,出生日期,黨員否,參加工作,部門號)go exec Addworker 39。,39。,39。,39。,39。,39。,39。（2）創(chuàng)建一個存儲過程Delworker刪除worker表中指定職工號的記錄 goif exists(select name from sysobjects where name=39。 and type=39。)drop procedure Delworker go create procedure Delworker 職工號 char(4)as delete from worker where 職工號=職工號go exec Delworker 39。（3）顯示存儲過程Delworker的定義信息。drop procedure Addworker, Delworker（5）創(chuàng)建并執(zhí)行以下存儲過程：，返回學生學號、姓名、課程名、成績 use 霍雙雙200826351 go if exists(select name from sysobjects where name=39。 and type=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 ，姓名，該存儲過程接受與傳遞參數(shù)，精確匹配的值 use 霍雙雙200826351 go if exists(select name from sysobjects where name=39。 and type=39。)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。 第三部分：觸發(fā)器(1)在表depart上創(chuàng)建一個觸發(fā)器 depart_update , 當更改部門號時同步更改 worker表中對應的部門號。depart_update39。tr39。Go If exists(select name from sysobjects where name=39。and type=39。)drop trigger worker_delete go create trigger worker_delete on worker for delete as delete salary where =(select 職工號 from deleted)(3)刪除觸發(fā)器depart_update(4)刪除觸發(fā)器worker_delete(5)在數(shù)據(jù)庫中創(chuàng)建一個觸發(fā)器，向選課表添加一條紀錄時，檢查該紀錄的學號在學生表中是否存在，檢查該紀錄的課程號在課程表中是否存在，若其中有一項為否，則拒絕添加操作，并顯示“違反數(shù)據(jù)一致性”提示信息。add_student39。tr39。男39。default_sex39。39。[0~9999]39。salary_rule39。39。建立一個規(guī)則 sex：性別=’男’OR 性別=’女’,將其綁定到worker表的“性別”列上。男39。女39。sex39。39。刪除2小題所建立的約
公司管理相關推薦
鄂ICP備17016276號-1