醫(yī)藥銷(xiāo)售管理及數(shù)據(jù)庫(kù)原理課程設(shè)計(jì)doc(參考版)
2025-07-20 21:11本頁(yè)面
【正文】 咨詢(xún)電話：020.值班手機(jī)：.網(wǎng)站網(wǎng)址：....24 / 24。,16,1)rollback transactionend.（.....）成立于2004年，專(zhuān)注于企業(yè)管理培訓(xùn)。create proc MedInfor_update_procMedicineCode1 char(6),MedicineName varchar(8),MedKindeCode char(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ǔ)過(guò)程實(shí)現(xiàn)單表查詢(xún)*/ /*建立名為“單表查詢(xún)1”的存儲(chǔ)過(guò)程，用來(lái)查詢(xún)某種藥品的信息*/ create proc 單表查詢(xún)1MedicineCode char(6)ASselect *from MedInfor where MedicineCode=MedicineCode /*建立名為“單表查詢(xún)2”的存儲(chǔ)過(guò)程，用來(lái)查詢(xún)某個(gè)客戶(hù)的信息*/ create proc 單表查詢(xún)2GuestCode char(10)ASselect *from GueInfor where GuestCode=GuestCode /*建立名為“單表查詢(xún)3”的存儲(chǔ)過(guò)程，用來(lái)查詢(xún)某個(gè)員工的信息*/ create proc 單表查詢(xún)3WorkNo char(10)ASselect *from WorkInfor where WorkNo=WorkNo /*建立名為“單表查詢(xún)4”的存儲(chǔ)過(guò)程，用來(lái)查詢(xún)某個(gè)供應(yīng)商的信息*/ create proc 單表查詢(xún)4FirmCode char(10)ASselect *from FirmInfor where FirmCode=FirmCode /*建立名為“單表查詢(xún)5”的存儲(chǔ)過(guò)程，用來(lái)查詢(xún)某個(gè)藥品代碼對(duì)應(yīng)的藥品類(lèi)型的信息*/ create proc 單表查詢(xún)5MedKindeCode char(10)ASselect *from MedID where MedKindeCode=MedKindeCode/*建立存儲(chǔ)過(guò)程實(shí)現(xiàn)連接查詢(xún)*/ /*建立名為“連接查詢(xún)1”的存儲(chǔ)過(guò)程，用來(lái)查詢(xún)某個(gè)藥品名稱(chēng)對(duì)應(yīng)的藥品類(lèi)型的信息*/ create proc 連接查詢(xún)1MedicineName varchar(8)asselect MedicineName ,KindExplanationfrom MedInfor,MedIDwhere = and MedicineName=MedicineName/*建立名為“連接查詢(xún)2”的存儲(chǔ)過(guò)程，用來(lái)查詢(xún)某個(gè)供應(yīng)商提供的藥品類(lèi)型*/ create proc 連接查詢(xún)2FirmName varchar(16)asselect FirmName,KindExplanationfrom MedInfor,MedID,FirmInforwhere = and = and FirmName=FirmName/*建立名為“連接查詢(xún)3”的存儲(chǔ)過(guò)程，用來(lái)查詢(xún)某個(gè)銷(xiāo)售員銷(xiāo)售某種藥品的數(shù)量*/create proc 連接查詢(xún)3Name varchar(12),MedicineName varchar(8)asselect name ,from WorkInfor,sellChild,MedInfor,sellMainwhere = and = and = and name=Name and =MedicineName/*建立名為“連接查詢(xún)4”的存儲(chǔ)過(guò)程，用來(lái)查詢(xún)某類(lèi)藥品的銷(xiāo)售量*/create proc 連接查詢(xún)4KindExplanation varchar(12)asselect KindExplanation,from sellChild,MedID,MedInfor where = and = and KindExplanation=KindExplanation/*建立名為“連接查詢(xún)5”的存儲(chǔ)過(guò)程，用來(lái)查詢(xún)某個(gè)員工銷(xiāo)售的藥品類(lèi)型*/create proc 連接查詢(xún)5Name varchar(12)asselect Name,KindExplanationfrom sellChild,MedID,MedInfor,sellMain,WorkInfor where = and = and =
電大資料相關(guān)推薦
鄂ICP備17016276號(hào)-1