delete todeliver
delete saleorder
delete saledetail
delete lading
delete ladingdetail
delete productflow
delete moneystream
delete tmpmoneystream
delete materialflow
delete purchase
delete purchasedetail
delete productcount
delete bill
delete expenses
delete materialcount
delete overmoney
delete payable
delete pays
delete receivable
delete receivedcount
delete salecount
delete salesmoney
-- delete tmpproductupdate product set inputnum=0,outputnum=0,thismonthnum=0,lastmonthnum=0,thismonthprice=0,lastmonthprice=0
update material set inputnum=0,outputnum=0,thismonthnum=0,lastmonthnum=0,price=0,thismonthvalue=0,lastmonthvalue=0
update glideid set saleorder=0,lading=0,productflow=0,stock=0,stuffflow=0,purchase=0,payorrec=0,receive=0,bill=0,salesmoney=0
insert overmoney select customerid,0,0,-1 from customer where customerid<>0
insert overmoney select 0,providerid,0,1 from provider where providerid<>0--------------------------------------------------------
在上面数据库里删除2006记录以前,怎么写呀
delete saleorder
delete saledetail
delete lading
delete ladingdetail
delete productflow
delete moneystream
delete tmpmoneystream
delete materialflow
delete purchase
delete purchasedetail
delete productcount
delete bill
delete expenses
delete materialcount
delete overmoney
delete payable
delete pays
delete receivable
delete receivedcount
delete salecount
delete salesmoney
-- delete tmpproductupdate product set inputnum=0,outputnum=0,thismonthnum=0,lastmonthnum=0,thismonthprice=0,lastmonthprice=0
update material set inputnum=0,outputnum=0,thismonthnum=0,lastmonthnum=0,price=0,thismonthvalue=0,lastmonthvalue=0
update glideid set saleorder=0,lading=0,productflow=0,stock=0,stuffflow=0,purchase=0,payorrec=0,receive=0,bill=0,salesmoney=0
insert overmoney select customerid,0,0,-1 from customer where customerid<>0
insert overmoney select 0,providerid,0,1 from provider where providerid<>0--------------------------------------------------------
在上面数据库里删除2006记录以前,怎么写呀
解决方案 »
- 递归查询问题
- 收藏 不显示删除回复显示所有回复显示星级回复显示得分回复 sql2005已经允许远程连接,为何还报错:不允许进行远程连接可能会导致此失败
- Sql Server 版權問題,請大家幫忙,謝謝!
- 数据量引发的问题
- 把表中的记录中字段为null的值,变成0
- sql2000备份文件还原时提示内部一致性错误,怎么解决!急急急
- 今天调试java程序,被迫在windows 2003 server上装sql server 2000出现问题!!
- 设计数据库时字段怎么起名?
- 数据库设计问题
- 关于把sql anywhere数据库转换成sql server数据库的方法,如何做?具体请进。。。.
- 求教-----级联删除的两个表,子表的触发器问题?
- log explorer的使用问题
这个没有统一的语句,要根据你的Table Schema来分析.