動行環境 sql server 2008,經常出現系統執行陳述句部分不成功問題,如下:
陳述句1:
update BOM_NX set quit_process_warehose=(quit_process_warehose+('0' )) , warehose_process_ng=(prd_process_ng-('0' )) ,quit_in_warehose=(quit_in_warehose+('9' )) ,warehose_ok=(warehose_ok-('0' )),quit_transfer=(quit_transfer+('0') ),warehose_in_ng=(warehose_in_ng-('9' )) where pnnumber='8282140004'
陳述句2:
update prt_warehoseout_data set checktime='2021/5/19 10:40:38',check_op='郭XX' where out_prt_num='W210519003' and ware_type='A'
諾句1:未發現例外
諾句2:有時候出現warehose_in_ng=(warehose_in_ng-('9' ))執行成功了,quit_in_warehose=(quit_in_warehose+('9' ))不成功問題,有解嗎?
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/284506.html
標籤:基礎類