【文章內容簡介】 潰瘍39。exec MedID_proc 39。000239。,39。感冒39。exec MedID_proc 39。000339。,39。發(fā)燒39。exec MedID_proc 39。000439。,39。拉肚子39。exec MedID_proc 39。000539。 ,39。外傷39。create proc MedInfor_proc@MedicineCode 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。100139。,39。板藍根39。,39。000239。,5,3,39。10039。,39。01439。,39。201012539。exec MedInfor_proc 39。200239。,39。四季感康39。,39。000239。,14,39。15039。,39。05139。,39。2010121239。exec MedInfor_proc 39。200339。,39。銀黃顆粒39。,39。000239。,12, 39。120 39。,39。01439。,39。201210639。exec MedInfor_proc 39。200439。,39。感冒清熱軟膠囊39。,39。000239。,17,12, 39。15039。,39。01539。, 39。201111139。exec MedInfor_proc 39。300139。,39。阿斯匹林39。,39。000339。,15,11,39。10039。,39。01439。,39。201012139。exec MedInfor_proc 39。300239。,39。布洛芬39。,39。000339。,21,39。12039。,39。05139。,39。20106539。exec MedInfor_proc 39。400139。,39。瀉利挺39。,39。000439。,25,20,39。12039。,39。01539。,39。201210239。exec MedInfor_proc 39。400239。,39。諾氟沙星膠囊39。,39。000439。,15,12,39。10039。,39。01539。,39。201291639。exec MedInfor_proc 39。500139。,39。碘酒39。,39。000539。,5,39。5039。 ,39。05139。,39。2012101239。exec MedInfor_proc 39。500239。,39。創(chuàng)口貼39。,39。000539。,2,1,39。25039。,39。01439。,39。20155139。create proc GueInfor_proc@GuestCode 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。01511239。,39。zhangsan39。,39。xiaozhang39。,39。66840139。,39。jiaxing39。exec GueInfor_proc 39。06511439。,39。lisi39。,39。xiaofang39。,39。61442539。,39。yuyao39。exec GueInfor_proc 39。05211439。,39。wangwu39。,39。xiaowu39。,39。65902439。,39。wenzhou39。exec GueInfor_proc 39。04311539。,39。zhaoliu39。,39。xiaowu39。,39。61587439。,39。shangyu39。exec GueInfor_proc 39。01422139。,39。awu39。,39。xiaozhang39。,39。65128339。,39。linan39。exec GueInfor_proc 39。02547139。,39。asha39。,39。xiaofang39。,39。69147239。,39。dongyang39。create proc FirmInfor_proc@FirmCode 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。01539。,39。yangshengtang39。,39。xiaotai39。,39。68147239。,39。huzhou39。exec FirmInfor_proc 39。01439。,39。baozhilin39。,39。zhangqing39。,39。65842139。,39。deqing39。exec FirmInfor_proc 39。05139。,39。pinmingdayaofang39。,39。oudan39。,39。6541739。,39。xiangshan39。create proc WorkInfor_proc@WorkNo 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。07510139。,39。ZKL39。,39。zkl0139。,39。45678939。,39。jingli39。,39。39。exec WorkInfor_proc 39。07520139。,39。ZJM39。,39。zjm0139。,39。12378939。,39。dongshi39。,39。39。exec WorkInfor_proc 39。07521539。,39。WMX39。,39。wmx0539。,39。14725839。,39。xiaomi39。,39。39。exec WorkInfor_proc 39。07512039。,39。ZZW39。,39。zzm2039。,39。12345639。,39。buzhang39。,39。39。create proc sellMain_proc@SaleNo int,@WorkNo char(10),@SaleDate DateTime,@Amount Moneyasinsert into sellMain(SaleNo,WorkNo,SaleDate,Amount)values(@SaleNo,@WorkNo,@SaleDate,@Amount)exec sellMain_proc 39。1239。,39。07510139。,39。20091139。,1000exec sellMain_proc 39。1339。,39。07520139。,39。20091139。,1500exec sellMain_proc 39。1539。,39。07521539。,39。20091139。,800exec sellMain_pr