资源描述:
《各种问题代码解决》由会员上传分享,免费在线阅读,更多相关内容在工程资料-天天文库。
1、◊储值卡余额减掉剩余白分之10:ALTERview[dbo].[VIW_VIP]asselectA.VIPID,A.PID,A.CBDID,A.RAT,A.VIPRAT,A.VIPNO,A.SNO,A.NAME,A.RANK,A.RANK_DSC,A.DISCRAT,A.SEX,A.SEX_DSC,A.IDNO,A.ADDR,A.TEL,A.PCODE,A.BIRTH,A.VDAT,A.IS_VALID,A.IS_DC,A.IS_USEONCE,A.CAN_POINT,A.CAN_BLC,A.CAN_VIPPRC,A.COMNAME,A.DUTY,A.WORK
2、,A.MARRIED,A.TECH,A.TECH_DSC,A.1NCOME,A.1NCOME_DSC,A.AREA,A.MOBILE,A.HOBY,A.EMA1L,A.REGID,A.CREDITAMT,A.POINT,A.NATION,A.INDAT,A.INPSN,A.DSC,C.ADD_CNT,C.ADD_SUM,C.BCK_CNT,C.BCK_SUM,C.CST_CNT,C.CST_SUM,C.FRZ_AMT,BLC_AMT=convert(numeric(12,2),C.BLC_AMT/10),BLC_SUM=convert(numeric(12,2
3、),C.BLC_SUM/10),C.POT_CNT,C.POT_SUM,A.RVERfromBAS.VIPAleftjoinBAS_VIPBLCConA.VIPID=C.VIPID◊--盘点单据审核不过去:selectIS_VALIDfromDOC_PD_BFwhereDOCNO-221404031355430002’updateDOC_PD_BFsetIS_VAL1D=1whereDOCNO-221404031355430002’◊会员卡处理终端查询:select*fromBAS.VIPPOINT◊审核库存成本调整:select*fromdoc_pt_bfw
4、heredocno=031508221035221001selectIS_VALIDFROMDOC_PT_BFwheredocno=031508221035221001UPDATEDOC_PT_BFSETIS_VALID=1wheredocno=*031508221035221001'◊-连锁传输不下去select*fromdbo.SYS_VERupdatedbo.SYS_VERsetVALUE二‘0’whereNAMElike&1003’修改商品配送属性:◊修改全部商品配送属性:updateBAS_PLU_MAINsetPSTYPE二3◊按照供货商修改商品配
5、送属性:select*fromBAS_PLU_MAINwherec.comnoupdateBAS_PLU_MAINsetPSTYPE=11updateAsetPSTYPE=4fromBAS_PLU_MAINAinnerjoinVIW_COM_PLUBonA.PLUID=B.PLUIDinnerjoinBAS_COMPANYConB.COMID=C.COMIDwhereC.COMID-60001’◊按照商品积分条件修改商品配送属性:select*fromBAS_PLU_MAINwhereVIPRAT=-10updateBAS_PLU_MAINsetPSTYPE=
6、3whereviprat=-10-每条语句单独执行,每句就是-条查询、一条删除前台系统初始化,后台删除流水后执行(删除POS高级杳询)◊清空流水:TRUNCATETRUNCATETRUNCATETRUNCATETRUNCATETABLETABLETABLETABLETABLEPOS_ADV_PAYPOS_ADV_PLUPOS_ADV_TIMPOS_ADV_PAY_COMPOS_ADV_PAY_PAYNO◊删除流水:deletefromPOS_ADV_PAY_COMwhereDAT<2014-05-0100:00*ANDDAT<*2014-05-0100:00'
7、◊删除POS供应商付款方式高级查询deletefromPOS_ADV_PAY_PAYNOwhereDAT<*2015-09-1800:004select*fromPOS_ADV_PAYselect*fromPOS_ADV_PLUselect*fromPOS_ADV_TIMTRUNCATETABLEPOS_ADV_PAY_COMTRUNCATETABLEPOS_ADV_PAY_PAYNO-清除而查询看看(删除会员及储值卡消费记录),不要执行-TRUNCATE-TRUNCATE-TRUNCATE-TRUNCATE-TRUNCATETABLEdbo.BAS_VIPT
8、ABLEdbo.BAS_VIPBLCT