【正文】 t for update as if UPDATE(Prmoney) begin select , as 原 價(jià) , as 現(xiàn)價(jià) from deleted,inserted where = end 圖 3. 更新零件 價(jià)格，效果圖如圖 Create trigger T_Part_money on Part for update as if UPDATE(Pamoney) begin select , as 原價(jià) , as 現(xiàn)價(jià) 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 檢測(cè) from deleted,inserted where = end 圖 七、總結(jié) 這次課程設(shè)計(jì)加深了我對(duì)數(shù)據(jù)庫(kù)系統(tǒng)概論相關(guān)知識(shí)和 SQL SERVER 相關(guān)功能的理解?；叵胫@個(gè)學(xué)期自己所學(xué)的《數(shù)據(jù)庫(kù)系統(tǒng)概論》、以及這次做的課程設(shè)計(jì)，感觸蠻深的。并在解決遇到的各種問(wèn)題的過(guò)程中，學(xué)到了很多新的知識(shí)。一般是先導(dǎo)入主鍵表，后導(dǎo)入外鍵表，這樣可以避免很多的錯(cuò)誤。每一個(gè)細(xì)微的細(xì)節(jié)都必須十分的注意，如果不認(rèn)真思考決策，就會(huì)出現(xiàn)或大或小的錯(cuò)誤，如果早期的錯(cuò)誤隱藏下來(lái)，對(duì)后面的工作影響就會(huì)很大，甚至有時(shí)要推倒很多前面做的工作重來(lái)。 另外比如功能過(guò)少等問(wèn)題，我會(huì)在工作的使用過(guò)程中，根據(jù)工作的具體要求不斷的修改，完善，爭(zhēng)取使該系統(tǒng)慢慢趨向完美。 exec C_Factory39。,39。 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。 exec C_Workhome 39。,39。,39。,39。,39。 create proc C_Worker Wono char(10), Woname char(20), Woage smallint, Wosex char(2), Wotype char(20), Wno char(10) as insert into worker values(Wono,Woname,Woage,Wosex,Wotype,Wno) exec C_Worker39。,39。,39。,39。,39。,39。 exec C_Worker39。,39。,39。,39。,39。,39。 exec C_Worker39。,39。,39。,39。,39。,39。 exec C_Worker39。,39。,39。,39。,39。,39。 exec C_Worker39。,39。,39。,39。,39。,39。 exec C_Worker39。,39。,39。,39。,39。,39。 exec C_Worker39。,39。,39。,39。,39。,39。 exec C_Worker39。,39。,39。,39。,39。,39。 exec C_Worker39。,39。,39。,39。,39。,39。 exec C_Worker39。,39。,39。,39。,39。,39。 exec C_Worker39。,39。,39。,39。,39。,39。 exec C_Worker39。,39。,39。,39。,39。,39。 select *from Worker create proc C_Storage Sno char(10), SMno char(20), Sphone char(11) as insert into Storage values(Sno,SMno,Sphone) exec C_Storage39。,39。,39。 exec C_Storage39。,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。,39。,39。,39。 exec C_Product39。,39。,39。,39。,39。,39。 exec C_Product39。,39。,39。,39。,39。,39。 insert into product(Prno,Prname,Prmoney,Prquantity,Sno,Wno) values(39。,39。,39。,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。 exec C_Part39。,39。,39。,39。,39。 exec C_Part39。,39。,39。,39。,39。 delete from Part where Pano=39。 select *from Part Create Proc C_Make Wno char(10), Pano char(10), Mtime varchar(20), Mquantity int as insert into Make values(Wno,Pano,Mtime,Mquantity) exec C_Make39。,39。,39。,39。 exec C_Make39。,39。,39。,39。 exec C_Make39。,39。,39。,39。 select *from Make Create Proc C_Compose Prno char(10), Pano char(10), Cquantity int as insert into Compose values(Prno,Pano,Cquantity) exec C_Compose39。,39。,39。 exec C_Compose39。,39。,39。 exec C_Compose39。,39。,39。 exec C_Compose39。,39。,39。 exec C_Compose39。,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_Store139。,39。,39。 Create proc C_Store2 Sno char(10), Pano char(10), Squantity2 int as insert into Store2 values(Sno,Pano,Squantity2) exec C_Store239。,39。,39。 exec C_Store239。,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 檢測(cè) from deleted,inserted where = end update Part set Paweight=39。 where Paweight39。 update Part set Paweight=39。 where Pano=39。 update Part set Paweight=39。 where Pano=39。 update Part set Paweight=39。 where Pano=39。 DROP trigger T_Part Create trigger T_Product_money on Product for update as if UPDATE(Prmoney) begin select , as 原價(jià) , as 現(xiàn)價(jià) from deleted,inserted where = end update Product set Prmoney=39。 where Prno=39。 Create trigger T_Part_money on Part for update as if UPDATE(Pamoney) begin select , as 原價(jià) , as 現(xiàn)價(jià) from deleted,inserted where = end update Part set Pamoney=39。 where Pano=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。 where wono=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 倉(cāng)庫(kù)號(hào) ,Prno as 產(chǎn)品號(hào) ,Squantity1 as 產(chǎn)品存儲(chǔ)數(shù) from Store1 drop trigger T_Product update Product set Prquantity=39。 where Prno=39。