【正文】 c WorkInfor_proc 39。,39。,39。,39。,39。,39。exec WorkInfor_proc 39。,39。,39。,39。,39。,39。create proc WorkInfor_procWorkNo char(10),Name varchar(12),UserRegName char(6),Password char(10),Position char(10),Power Intasinsert into WorkInfor(WorkNo,Name,UserRegName,Password,Position,Power)values(WorkNo,Name,UserRegName,Password,Position,Power)exec WorkInfor_proc 39。,39。,39。,39。,39。exec FirmInfor_proc 39。,39。,39。,39。,39。exec FirmInfor_proc 39。,39。,39。,39。,39。create proc FirmInfor_procFirmCode char(10),FirmName varchar(16),Link varchar(12),LinkTell varchar(11),City varchar(8)asinsert into FirmInfor(FirmCode,FirmName,Link,LinkTell,City)values(FirmCode,FirmName,Link,LinkTell,City)exec FirmInfor_proc 39。,39。,39。,39。,39。exec GueInfor_proc 39。,39。,39。,39。,39。exec GueInfor_proc 39。,39。,39。,39。,39。exec GueInfor_proc 39。,39。,39。,39。,39。exec GueInfor_proc 39。,39。,39。,39。,39。exec GueInfor_proc 39。,39。,39。,39。,39。create proc GueInfor_procGuestCode char(10),GuestName varchar(16),GLink varchar(12),GLinkTell varchar(11),City varchar(8)asinsert into GueInfor(GuestCode,GuestName,GLink,GLinkTell,City) values(GuestCode,GuestName,GLink,GLinkTell,City)exec GueInfor_proc 39。,39。,39。,2,1,39。,39。,39。exec MedInfor_proc 39。,39。 ,39。,5,39。,39。,39。exec MedInfor_proc 39。,39。,39。,15,12,39。,39。,39。exec MedInfor_proc 39。,39。,39。,25,20,39。,39。,39。exec MedInfor_proc 39。,39。,39。,21,39。,39。,39。exec MedInfor_proc 39。,39。,39。,15,11,39。,39。,39。exec MedInfor_proc 39。, 39。,39。,17,12, 39。,39。,39。exec MedInfor_proc 39。,39。,39。,12, 39。,39。,39。exec MedInfor_proc 39。,39。,39。,14,39。,39。,39。exec MedInfor_proc 39。,39。,39。,5,3,39。,39。,39。create proc MedInfor_procMedicineCode char(6),MedicineName varchar(8),MedKindeCode char(10),Price money,ListPrice money,Number int,FirmCode char(10),Userfulllife Datetimeasinsert into MedInfor(MedicineCode ,MedicineName,MedKindeCode,Price,ListPrice,Number,Supplicer,Userfulllife) values(MedicineCode,MedicineName,MedKindeCode,Price,ListPrice,Number,FirmCode,Userfulllife)exec MedInfor_proc 39。 ,39。exec MedID_proc 39。,39。exec MedID_proc 39。,39。exec MedID_proc 39。,39。exec MedID_proc 39。,39。參考文獻(xiàn)：[1] 苗雪蘭，劉瑞新，[M].[2] 薩師煊，王 [M].北京：[3] SERVER2000培訓(xùn)教程[M].北京：[4] 2000+ ASP SQL Server案例教程[M].上海: [5] +SQLSERVER網(wǎng)絡(luò)應(yīng)用系統(tǒng)開發(fā)指南[M].附錄：create database MedicalManagerSystem/*創(chuàng)建醫(yī)藥銷售管理系統(tǒng)*/use MedicalManagerSystemcreate table MedID/*創(chuàng)建藥品類別索引信息*/ (MedKindeCode char(10) constraint MI_PRI PRIMARY KEY, KindExplanation varchar(12) NOT NULL)create table MedInfor/*創(chuàng)建藥品信息表*/ (MedicineCode char(6) constraint M_PRIM PRIMARY KEY, MedicineName varchar(8) NOT NULL, MedKindeCode char(10) FOREIGN KEY REFERENCES MedID(MedKindeCode), Price Money, ListPrice Money, Number Int, FirmCode char(10) FOREIGN KEY REFERENCES FirmInfor(FirmCode), Userfulllife Datetime)create table GueInfor/*創(chuàng)建客戶信息表*/ (GuestCode char(10) constraint G_PRIM PRIMARY KEY, GuestName varchar(16) NOT NULl, GLink varchar(12), GLinkTell varchar(11), City varchar(8))create table FirmInfor/*創(chuàng)建供應(yīng)商信息表*/ (FirmCode char(10) constraint F_PRIM PRIMARY KEY, FirmName varchar(16) NOT NULL, Link varchar(12), LinkTell varchar(11), City varchar(8))create table WorkInfor/*創(chuàng)建員工信息表*/ (WorkNo char(10) constraint W_PRIM PRIMARY KEY, Name varchar(12), UserRegName char(6) NOT NULL, Password char(10) NOT NULL, Position char(10), Power Int) create table sellMain/*創(chuàng)建醫(yī)藥銷售主表*/ (SaleNo int constraint SM_PRIM PRIMARY KEY, WorkNo char(10) FOREIGN KEY REFERENCES WorkInfor(WorkNo),