醫(yī)藥銷售管理及數(shù)據(jù)庫(kù)原理課程設(shè)計(jì)(文件)
【正文】 10),Price money,ListPrice money,Number int,FirmCode char(10),Userfulllife Datetime,MedicineCode char(6)asupdate MedInforset MedicineCode=MedicineCode1,MedicineName=MedicineName,MedKindeCode=MedKindeCode,Price=Price,ListPrice=ListPrice,Number=Number,FirmCode=FirmCode,Userfulllife=Userfulllife,MedicineCode=MedicineCodewhere MedKindeCode=MedKindeCode create proc GueInfor_update_procGuestCode1 char(10),GuestName varchar(16),GLink varchar(12),GLinkTell varchar(11),City varchar(8),GuestCode char(10)asupdate GueInforset GuestCode=GuestCode1,GuestName=GuestName,GLink=GLink,GLinkTell=GLinkTell,City=Citywhere GuestCode=GuestCodecreate proc FirmInfor_update_procFirmCode1 char(10),FirmName varchar(16),Link varchar(12),LinkTell varchar(11),City varchar(8),FirmCode char(10)asupdate FirmInforset FirmCode=FirmCode1,FirmName=FirmName,Link=Link,LinkTell=LinkTell,City=Citywhere FirmCode=FirmCodecreate proc WorkInfor_update_procWorkNo1 char(10),Name varchar(12),UserRegName char(6),Password char(10),Position char(10),Power Int,WorkNo char(10)asupdate WorkInforset WorkNo=WorkNo1,Name=Name,UserRegName=UserRegName,Password=Password,Position=Position,Power=Powerwhere WorkNo=WorkNocreate proc sellMain_update_procSaleNo1 int,WorkNo char(10),SaleDate DateTime,Amount Money,SaleNo intasupdate sellMainset SaleNo=SaleNo1,WorkNo=WorkNo,SaleDate=SaleDate,Amount=Amountwhere SaleNo=SaleNocreate proc sellChild_update_procSaleNo1 int,MedicineCode char(6),MedicineName varchar(32),Price Money,Number Int,Uint char(8),Amount Money,SaleNo intasupdate sellChildset SaleNo=SaleNo1,MedicineCode=MedicineCode,MedicineName=MedicineName,Price=Price,Number=Number,Amount=Amountwhere SaleNo=SaleNo/*建立存儲(chǔ)過程實(shí)現(xiàn)單表查詢*/ /*建立名為“單表查詢1”的存儲(chǔ)過程，用來查詢某種藥品的信息*/ create proc 單表查詢1MedicineCode char(6)ASselect *from MedInfor where MedicineCode=MedicineCode /*建立名為“單表查詢2”的存儲(chǔ)過程，用來查詢某個(gè)客戶的信息*/ create proc 單表查詢2GuestCode char(10)ASselect *from GueInfor where GuestCode=GuestCode /*建立名為“單表查詢3”的存儲(chǔ)過程，用來查詢某個(gè)員工的信息*/ create proc 單表查詢3WorkNo char(10)ASselect *from WorkInfor where WorkNo=WorkNo /*建立名為“單表查詢4”的存儲(chǔ)過程，用來查詢某個(gè)供應(yīng)商的信息*/ create proc 單表查詢4FirmCode char(10)ASselect *from FirmInfor where FirmCode=FirmCode /*建立名為“單表查詢5”的存儲(chǔ)過程，用來查詢某個(gè)藥品代碼對(duì)應(yīng)的藥品類型的信息*/ create proc 單表查詢5MedKindeCode char(10)ASselect *from MedID where MedKindeCode=MedKindeCode/*建立存儲(chǔ)過程實(shí)現(xiàn)連接查詢*/ /*建立名為“連接查詢1”的存儲(chǔ)過程，用來查詢某個(gè)藥品名稱對(duì)應(yīng)的藥品類型的信息*/ create proc 連接查詢1MedicineName varchar(8)asselect MedicineName ,KindExplanationfrom MedInfor,MedIDwhere = and MedicineName=MedicineName/*建立名為“連接查詢2”的存儲(chǔ)過程，用來查詢某個(gè)供應(yīng)商提供的藥品類型*/ create proc 連接查詢2FirmName varchar(16)asselect FirmName,KindExplanationfrom MedInfor,MedID,FirmInforwhere = and = and FirmName=FirmName/*建立名為“連接查詢3”的存儲(chǔ)過程，用來查詢某個(gè)銷售員銷售某種藥品的數(shù)量*/create proc 連接查詢3Name varchar(12),MedicineName varchar(8)asselect name ,from WorkInfor,sellChild,MedInfor,sellMainwhere = and = and = and name=Name and =MedicineName/*建立名為“連接查詢4”的存儲(chǔ)過程，用來查詢某類藥品的銷售量*/create proc 連接查詢4KindExplanation varchar(12)asselect KindExplanation,from sellChild,MedID,MedInfor where = and = and KindExplanation=KindExplanation/*建立名為“連接查詢5”的存儲(chǔ)過程，用來查詢某個(gè)員工銷售的藥品類型*/create proc 連接查詢5Name varchar(12)asselect Name,KindExplanationfrom sellChild,MedID,MedInfor,sellMain,WorkInfor where = and = and = and = and Name=Name建立存儲(chǔ)過程實(shí)現(xiàn)嵌套查詢/*建立名為“嵌套查詢1”的存儲(chǔ)過錯(cuò)，用來查詢某類藥品的銷售量*/create proc 嵌套查詢1KindExplanation varchar(12)asselect Number from sellChild where MedicineCode In(select MedicineCode
電大資料相關(guān)推薦
鄂ICP備17016276號(hào)-1