Dynamic SQL server 2008 line environment, often appear part system to execute the statement is not successful, the following:
Statement 1:
The 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'
Statement 2:
The update prt_warehoseout_data set checktime='2021/5/19 10:40:38', check_op='guo XX where out_prt_num=' W210519003 'and ware_type=' A '

Sentence 1: no abnormalities are found
Sentence 2: sometimes appear warehose_in_ng=(warehose_in_ng - (' 9 ')) succeeded, quit_in_warehose=(quit_in_warehose + (' 9 ')) is not successful, have a solution?