我用的一个sqlserver2000的数据库.是一个收银软件,要报错:
题目
我用的一个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_am...
举一反三
我想写一篇关于奥巴马的演讲的文章,写哪一篇好呢?为什么好
最新试题
热门考点