试试这个:Alter table t_allocate_d disable trigger all delete t_allocate_d from t_allocate_h where t_allocate_h.allocateno = t_allocate_d.allocateno and t_allocate_h.alloctype = '12' and t_allocate_d.allocateno = '200403268108' and --填写配送单号 itemno = '0217137' --填写店内码 and shipno = '0312044' --填写此商品批号(如果想不要此条件,请在and之前加上--)Alter table t_allocate_d enable trigger all
Alter table t_allocate_d disable trigger all delete t_allocate_d from t_allocate_h where t_allocate_h.allocateno = t_allocate_d.allocateno and t_allocate_h.alloctype = '12' and t_allocate_h.allocateno = '200403268108' --填写配送单号 and t_allocate_h.itemno = '0217137' --填写店内码 and t_allocate_h.shipno = '0312044' --填写此商品批号(如果想不要此条件,请在and之前加上--)Alter table t_allocate_d enable trigger all
from t_allocate_h
where t_allocate_h.allocateno = t_allocate_d.allocateno and
t_allocate_h.alloctype = '12' and t_allocate_d.allocateno = '200403268108' and --填写配送单号
itemno = '0217137' --填写店内码
and shipno = '0312044' --填写此商品批号(如果想不要此条件,请在and之前加上--)Alter table t_allocate_d enable trigger all
from t_allocate_h
where t_allocate_h.allocateno = t_allocate_d.allocateno
and t_allocate_h.alloctype = '12'
and t_allocate_h.allocateno = '200403268108' --填写配送单号
and t_allocate_h.itemno = '0217137' --填写店内码
and t_allocate_h.shipno = '0312044' --填写此商品批号(如果想不要此条件,请在and之前加上--)Alter table t_allocate_d enable trigger all