作业帮 > 综合 > 作业

我用的一个sqlserver2000的数据库.是一个收银软件,要报错:

来源:学生作业帮 编辑:作业帮 分类:综合作业 时间:2024/07/14 03:16:32
我用的一个sqlserver2000的数据库.是一个收银软件,要报错:
No changes made to database.
INSERT INTO ta_t_jxc_daysum ( branch_no,item_no,oper_date,cost_price,init_qty,init_amt,init_amt2,in_qty,in_amt,pi_qty,pi_amt,ro_qty,ro_amt,gi_qty,gi_amt,avg_cost_amt,avg_profit_amt,fifo_cost_amt,fifo_profit_amt,out_qty,out_amt,so_qty,so_amt,ri_qty,ri_amt,jo_qty,jo_amt,ko_qty,ko_amt,pos_qty,pos_amt,mi_qty,mi_amt,loss_qty,loss_amt,cso_qty,cso_amt,oo_qty,oo_amt,cho_qty,cho_amt,chi_qty,chi_amt,settle_qty,settle_amt,settle_amt2,start_date,end_date,num1,num2,num3,flag,sup_in_price,pos_dct_amt,pos_zs_amt,main_sup ) VALUES ( '00','6926597102016','2010-01-08',0.6000,30.0000,18.0000,75.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.8000,5.7000,1.8000,5.7000,3.0000,7.5000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,3.0000,7.5000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,27.0000,16.2000,67.5000,'2010-01-08','2010-01-11',0.6000,0.0000,0.0000,'0',0.6000,0.0000,0.0000,'' )
我忘了说,用的收银软件,用sqlserver2000的数据库支持的,因为停了几次电,所以那个收银软件现在用就报错 ,这个怎么解决啊,说下解决的方法啊,本人对这个不是很懂,麻烦说请粗点
禁止改变作向数据库.插入物INTO ta_t_jxc_daysumbranch_no item_nooper_date cost_priceinit_qty init_amtinit_amt2 in_qtyin_amt pi_qtypi_amt ro_qtyro_amt gi_qtygi_amt avg_cost_amtavg_profit_amt fifo_cost_amtfifo_profit_amt out_qtyout_amt so_qtyso_amt ri_qtyri_amt jo_qtyjo_amt ko_qtyko_amt pos_qtypos_amt mi_qtymi_amt loss_qtyloss_amt cso_qtycso_amt oo_qtyoo_amt cho_qtycho_amt chi_qtychi_amt settle_qtysettle_amtsettle_amt2,start_date,end_date,num1,num2,num3,旗帜,sup_in_price,pos_dct_amt,pos_zs_amt,main_sup VALUES'00'',6926597102016'',2010-01-08,0.6000,30.0000,18.0000,75.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.8000,5.7000,1.8000,5.70003.0000,7.5000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,3.0000,7.5000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,27.0000,16.2000,67.5000,2010-01-08'',2010-01-11',0.6000,0.0000,0.0000',0,0.6000,0.0000,0.0000