科脉御商超市系统V9.0sql server数据库修复操作记录
发布时间:2024/5/4 9:46:54 作者:Admin 阅读:174
广告:
采购退货单 ac_t_supjxc_in ac_t_supjxc_out
补差单 ac_t_supjxc_in (删除了PRIMARY KEY 约束'PK_AC_T_SUPJXC_IN'
调价单:pm_t_flow_detail pm_t_flow_master
门店对账表 pos_t_casher_daysum bi_t_payment_info.pay_way
ac_t_supjxc_in_hist ac_t_supjxc_in pm_t_flow_detail pm_t_flow_master
select top 200 * from ac_t_supjxc_in_hist order by oper_date desc
select top 200 * from pm_t_flow_detail order by oper_date desc
delete from ac_t_supjxc_in where oper_date >'2024-04-14 00:00:00'
delete from where oper_date >'2024-04-14 00:00:00'
select top 200 * from pm_t_flow_detail as a left join pm_t_flow_master as b on a.sheet_no=b.sheet_no where b.oper_date >'2024-04-14 00:00:00'
delete from pm_t_flow_detail as a left join pm_t_flow_master as b on a.sheet_no=b.sheet_no where b.oper_date >'2024-04-14 00:00:00'
delete a from pm_t_flow_detail as a join pm_t_flow_master as b on a.sheet_no=b.sheet_no where b.oper_date >'2024-04-14 00:00:00'
违反了 PRIMARY KEY 约束 'PK_POS_T_INTEGRAL_OPERATING'。不能在对象 'dbo.pos_t_integral_operating' 中插入重复键。
这是一篇受密码保护的文章,请输入密码进行访问:
广告:
相关文章