受孟浩然兄帮忙之SQL心得

阿尔山

--销售订单
update seorder set
Fdate=fdate 1 where
datename(weekday,FDate)='星期日'
--采购申请单
update PORequest set
Fdate=fdate 1 where
datename(weekday,FDate)='星期日'
--采购订单
update POOrder set
Fdate=fdate 1 where
datename(weekday,FDate)='星期日'

--生产任务单、委外加工任务单
update ICMO set
FCheckDate=FCheckDate 1 where
datename(weekday,FCheckDate)='星期日'

--生产投料单
update PPBOM set
Fdate=fdate 1where
datename(weekday,FDate)='星期日'

--生产投料变更单
update PPBOMchange Fdate
=fdate 1where
datename(weekday,FDate)='星期日'

--出入库单：
update ICStockBill set
Fdate=fdate 1 where
datename(weekday,FDate)='星期日'