【正文】 ，效果圖如圖 create procedure C_Workhome Wno char(10), WMno char(20), Wadd char(20), Wphone char(11), Fname char(20) as insert into Workhome values(Wno,WMno,Wadd,Wphone,Fname) exec C_Workhome 39。,39。,39。,39。,39。 exec C_Workhome 39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。 exec C_Storage39。,39。,39。 圖 ，效果圖如圖 create proc C_Product Prno char(10), Prname char(20), Prmoney int, Prquantity int, Sno char(10), Wno char(10) as insert into Product values(Prno,Prname,Prmoney,Prquantity,Sno,Wno) exec C_Product39。,39。,39。 exec C_Product39。,39。,39。 exec C_Product39。,39。,39。 insert into product(Prno,Prname,Prmoney,Prquantity,Sno,Wno) values(39。,39。,39。) 圖 ，效果圖如圖 Create proc C_Part Pano char(10), Paweight varchar(20), Pamoney int, Paquantity int, Sno char(10) as insert into Part values(Pano,Paweight,Pamoney,Paquantity,Sno) exec C_Part39。,39。,39。,39。,39。 exec C_Part39。,39。,39。,39。,39。 delete from Part where Pano=39。,39。,39。,39。,39。,39。,39。,39。 exec C_Compose39。,39。,39。 exec C_Compose39。,39。,39。 exec C_Compose39。,39。,39。 exec C_Compose39。,39。,39。 圖 ，效果圖如圖 Create proc C_Store1 Sno char(10), Prno char(10), Stquantity1 int as insert into Store1 values(Sno,Prno,Stquantity1) exec C_Store139。,39。,39。 exec C_Store139。,39。,39。 exec C_Store239。,39。,39。 圖 觸發(fā)器設(shè)計 ，效果圖如 create trigger T_Product on Product for update as if UPDATE(Prquantity) begin declare no int, Bo int select Bo=Prquantity,no=Prno from inserted update Store1 set Squantity1=Squantity1+Bo where Prno=no end select Sno as 倉庫號 ,Prno as 產(chǎn)品號 ,Squantity1 as 產(chǎn)品存儲數(shù) from Store1 圖 2. 更新產(chǎn)品價格，效果圖如圖 Create trigger T_Product_money on Product for update as if UPDATE(Prmoney) begin select , as 原 價 , as 現(xiàn)價 from deleted,inserted where = end 圖 3. 更新零件 價格，效果圖如圖 Create trigger T_Part_money on Part for update as if UPDATE(Pamoney) begin select , as 原價 , as 現(xiàn)價 from deleted,inserted where = end 圖 3. 更新職工職位 ，效果圖如圖 Create trigger T_worker on Worker for update as if UPDATE(Wotapy) begin select , as 原職位 , as 現(xiàn)職位 from deleted,inserted where = end 圖 ，效果圖如圖 Create trigger T_Part on Part for update as if UPDATE(Paweight) begin select , as 重量 , as 檢測 from deleted,inserted where = end 圖 七、總結(jié) 這次課程設(shè)計加深了我對數(shù)據(jù)庫系統(tǒng)概論相關(guān)知識和 SQL SERVER 相關(guān)功能的理解。并在解決遇到的各種問題的過程中，學(xué)到了很多新的知識。每一個細微的細節(jié)都必須十分的注意，如果不認真思考決策，就會出現(xiàn)或大或小的錯誤，如果早期的錯誤隱藏下來，對后面的工作影響就會很大，甚至有時要推倒很多前面做的工作重來。 exec C_Factory39。 select *from Factory create procedure C_Workhome Wno char(10), WMno char(20), Wadd char(20), Wphone char(11), Fname char(20) as insert into Workhome values(Wno,WMno,Wadd,Wphone,Fname) exec C_Workhome 39。,39。,39。,39。,39。 exec C_Workhome 39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。 exec C_Storage39。,39。,39。 select *from Storage create proc C_Product Prno char(10), Prname char(20), Prmoney int, Prquantity int, Sno char(10), Wno char(10) as insert into Product values(Prno,Prname,Prmoney,Prquantity,Sno,Wno) exec C_Product39。,39。,39。 exec C_Product39。,39。,39。 exec C_Product39。,39。,39。 insert into product(Prno,Prname,Prmoney,Prquantity,Sno,Wno) values(39。,39。,39。) select *from Product Create proc C_Part Pano char(10), Paweight varchar(20), Pamoney int, Paquantity int, Sno char(10) as insert into Part values(Pano,Paweight,Pamoney,Paquantity,Sno) exec C_Part39。,39。,39。,39。,39。 exec C_Part39。,39。,39。,39。,39。 delete from Part where Pano=39。,39。,39。,39。,39。,39。,39。,39。 exec C_Compose39。,39。,39。 exec C_Compose39。,39。,39。 exec C_Compose39。,39。,39。 exec C_Compose39。,39。,39。 select *from Compose Create proc C_Store1 Sno char(10), Prno char(10), Squantity1 int as insert into Store1 values(Sno,Prno,Squantity1) exec C_Store139。,39。,39。 exec C_Store139。,39。,39。 exec C_Store239。,39。,39。 select *from Store2 create index Factory_index on Factory(Fname) create index Workhome_index on Workhome(Wno) create index Worker_index on Worker(Wono) create index Product_index on Product(Prno) create index Part_index on Part(Pano) create index Storage_index on Storage(Sno) Create trigger T_Part on Part for update as if UPDATE(Paweight) begin select , as 重量 , as 檢測 from deleted,inserted where = end update Part set Paweight=39。 update Part set Paweight=39。 update Part set Paweight=39。 update Part set Paweight=39。 DROP trigger T_Part Create trigger T_Product_money on Product for update as if UPDATE(Prmoney) begin select , as 原價 , as 現(xiàn)價 from deleted,inserted where = end update Product set Prmoney=39。 Create trigger T_Part_money on Part for update as if UPDATE(Pamoney) begin select , as 原價 , as 現(xiàn)價 from deleted,inserted where = end update Part set Pamoney=39。 Create trigger T_worker on Worker for update as if UPDATE(Wotapy) begin select , as 原職位 , as 現(xiàn)職位 from deleted,inserted where = end update Worker set Wotapy=39。 create trigger T_Product on Product for update as if UPDATE(Prquantity) begin declare no int, Bo int select Bo=Prquantity,no=Prno from inserted update Store1 set Squantity1=Squantity1+Bo where Prno=no end select Sno as 倉庫號 ,Prno as 產(chǎn)品號 ,Squantity1 as 產(chǎn)品存儲數(shù) from Store1 drop trigger T_Product update Product set Prquantity=39。