执行SQL出错，时间：2025/1/22 11:39:06
SQL语句： insert into t_bd_item_info   (item_no,item_subno,item_name,item_subname,item_clsno,item_brand,item_brandname,unit_no,   item_size,product_area,price,base_price,sale_price,scheme_price, combine_sta  ,status,display_flag,   po_cycle,so_cycle,automin_flag,en_dis,change_price,purchase_tax,sale_tax,   purchase_spec,shipment_spec,item_supcust,main_supcust,item_sup_flag,sup_rate,item_stock,   build_date,modify_date,stop_date,return_rate,abc,branch_price,item_rem,vip_price,   sale_min_price,com_flag,vip_mark_percentage,box_conn_qty,item_day_clear,   vip_acc_flag,vip_acc_num,dpfm_type,base_price1,base_price2,base_price3,base_sn_flag,measure_flag,pro_code1,pro_code2,pro_code3,pro_code4,pro_code5,pro_code6,   sale_flag,en_gift,valid_days,new_oper_id,modify_oper_id,memo,vip_price2,vip_price3,vip_price4,vip_price5,base_price4,base_price5,base_price6,base_price7,base_price8,  item_picture,stock_type,ws_flag,not_sale_days,first_remind,second_remind,third_remind )   select rtrim(item_no)as item_no,item_subno,item_name,item_subname,item_clsno,item_brand,item_brandname,unit_no,     item_size,product_area,price,base_price,sale_price,scheme_price, combine_sta  ,status,display_flag,     po_cycle,so_cycle,automin_flag,en_dis,change_price,purchase_tax,sale_tax,    purchase_spec,shipment_spec,item_supcust,main_supcust,item_sup_flag,sup_ly_rate,CASE item_sup_flag WHEN 'C' THEN '0' ELSE item_stock END,    build_date,modify_date,stop_date,return_rate,abc,branch_price,item_rem,vip_price,   sale_min_price,com_flag,vip_mark_percentage,box_conn_qty,item_day_clear,   vip_acc_flag,vip_acc_num,dpfm_type,base_price1,base_price2,base_price3,base_sn_flag,measure_flag,isnull(pro_code1,''),isnull(pro_code2,''),isnull(pro_code3,''),isnull(pro_code4,''),isnull(pro_code5,''),isnull(pro_code6,''),   sale_flag,en_gift,valid_days,oper_id,modify_oper_id,memo,vip_price2,vip_price3,vip_price4,vip_price5,base_price4,base_price5,base_price6,base_price7,base_price8, item_picture,stock_type,ws_flag,not_sale_days,first_remind,second_remind,third_remind  from t_bd_appitem_info where item_no =@item_no and approve_flag = '0' 
参数值如下：
[@item_no:6975410632285] 
错误信息：
事务(进程 ID 56)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。
------------------------------------