游标、存储过程、触发器实验题

1、仓库仓库号城市面积WH1北京370WH2上海500WH3广州200WH4武汉400供应商供应商号供应商名地址G1微软广州G3大连实德北京职工仓库号职工号工资WH2E11220WH1E31210WH2E41250WH3E61230WH1E71250订购单职工号供应商号订购单号订购日期金额E1G1D31995-2-20500E2G3D22010-12-25500订购单明细订购单号订购单名单价负责人D1四大皆空230登记费D2数字机564斯蒂芬D3士大夫235斯蒂D4史蒂夫456发动机D5而感到345方的3实验八1、createtriggerwage_triggeron职工forupdateasde

2、clarewage_newint,wage_oldintselectwage_new=工资frominsertedselectwage_old=Xfromdeletedifwage_new>wage_old*1.06beginraiserror（'工资不可超过6%',16,1）rollbacktransactionend2、CREATETRIGGERdinggou_triggeron订购单forinsert,updateasdeclarewageintselectwage=订购单金额frominsertedifwage<3000beginif（selectcount

3、（*）frominsertedi,供应商g,职工z,仓库cwherei.供应商号=g.供应商号andi.职工号=z.职工号andz.仓库号=c.仓库号andc.城市=g.地址）=0beginraiserror（'当订购单金额小于3000时，必须使用本地供应商',16,1）rollbacktransactionendend实验七、1、createprocedurewage_procedurewage1int,wage2intasselect仓库.仓库号,城市,职工号,工资from仓库,职工where仓库.仓库号=职工.仓库号and工资>wage1and工资<wage2

4、declarewage1int,wage2int/此句可有可无executewage_procedure1200,12402、createprocedurebook2_proceduredatedatetimeasselect订购单.订购单号,供应商.*from供应商,订购单where供应商.供应商号=订购单.供应商号and订购日期>datedeclaredatedatetimeexecutebook_procedure''实验六、1、declaresnochar(10),singleint,instructorchar(10)declareaccount_cursorCursorforselect订购单.订购单号,单价,负责人from订购单join订购单明细on订购单.订购单号=订购单明细.订购单号orderby单价openaccount_cursorfetchfromaccount_cursorintosno,single,instructorwhilefetch_status=0beginprintsno+convert(char(10),single)+''+instructorfetchfromaccount_cu