您好,请您先 登陆 或者 注册

【官方】A3延期(不过期处理,用于演示,会清除业务数据)


问题补充:以下语句请在SQL查询分析器中,选择数据库执行:
update basItemInfo set create_date = GetDate(),modify_date = GetDate()
delete from memIntegralExchange
delete from memPriceDetail
delete from memPriceInfo
delete from memTypeInfo
delete from posGiftDetail
delete from posGiftMaster
delete from posGiveDetail
delete from posGiveMaster
delete from posSpecialDetail
delete from posSpecialMaster
delete from safLogFlow
delete from sysBillFlow
delete from sysDwStyle
delete from sysWorkstation
delete from posSalePay
delete from posSaleDetail
delete from posSaleMaster
delete from posOverDetail
delete from posOverMaster
delete from PosStoreMaster
delete from PosStoreDetail
delete from posoperLog
delete from depSheetDetail
delete from depSheetMaster
delete from depPriceDetail
delete from depPriceMaster
delete from depOrderDetail
delete from depOrderMaster
delete from depCheckDetail
delete from depCheckMaster
delete from depCheckInit_detail
delete from depCheckInit
delete from depCheckRange
delete from depStock
delete from depStock_every
delete from depCostFlow

提问者: 李祥
等级:问不倒翁
时间:2011-04-15 15:19
悬赏:0
解决时间:2011-04-25 15:19
回答 共 3 条
这么复杂啊,建议做个补丁,一点延长10天、什么的?只可以延长1-2次,要不然有人不付款啊
回答者:金帮手软件
等级:金牌会员
时间:2011-04-15 18:41
没做存储过程的,语句肯定长了...
回答者:小燕子
等级:钻石会员
时间:2011-04-17 10:52
建议把这个功能做到赢通工具里方便!
回答者:sunyubin
等级:铜牌会员
时间:2011-04-23 14:05
总积分排行
ytkf00720058 4704
kh35927124 3414
赢通技术43538 3053
bonchen13219 2797
赢通技术37615 2590
JCLH11087 1917
浅逝1873 1873
李祥19958 1542
xiaobird3309 1254
daoptt3310 1237